Exquisiteness对《Ocp》的笔记(1)

Exquisiteness
Exquisiteness (catyun)

在读 Ocp

Ocp
  • 书名: Ocp
  • 作者: Chip Dawes/Biju Thomas
  • 副标题: Oracle8I Dba SQL and Pl/SQL Study Guide : Exam 1Z0-001
  • 页数: 501
  • 出版社: Sybex Inc
  • 出版年: 2000-9
  • 第26页 Chapter 1 Relational Technology and Simple SQL SELECT Statements

    DESC The rows are returned by ascending order of the columns specified; if you need to sort the rows in descending order, use the kyword DESC net to name. Not only can you use the column or column alias to sort the result set of a query, you can also sort the results by position of the column in the SELECT clause. e.g. SELECT 'Name: ' || ename "Employee", SALARY "Salary" FROM emp WHERE deptno = 30 ORDER BY 2,1 SQL*Plus You can execute any database command or PL/SQL block in SQL*Plus, provided that you have the right privilege to do so. PL/SQL is Oracle's procedural extension of the SQL Language. In PL/SQL the SQL commands and procedural statements are considered to be a single block and sent to the Oracle server. If you omit the connect string, SQL*Plus tries to connect you to the local database defined in the ORACLE_SID variable. Once you are in SQL*Plus, you can connect to another database or change your connection by using the command CONNECT USERNAME/PASSWORD@CONNECTSTRING. If you omit the password, you will be prompted to enter it. You may omit the connect string to connect to a local database. EXIT/QUIT are synonymous. Teriminate a command End with a semicolon Enter a slash (/) on a new line by itself Enter a blank line. The command is saved in the buffer The RUN command can be used instead of a slas h to execute a command in the buffer. SQL Buffer The previously executed command will always available in the SQL buffer. The buffer can be edited or saved to a file.

    2013-12-19 22:00:43 回应

Exquisiteness的其他笔记  · · · · · ·  ( 全部214条 )

英语口语话题王
1
世界上最精彩的电影对白
5
别告诉我你懂PPT
7
OCA Oracle Database 11g SQL Fundamentals I Exam Guide
1
与孩子一起学编程
4
Visual Basic6程序设计与应用教程
7
The Complete Grimm's Fairy Tales
1
beginning sql server 2008 for developers
1
The C Programming Language
13
Windows Server 2008 for Dummies
1
Oracle 11g For Dummies
4
Database System Concepts
12
Microsoft SQL Server 2008 for Dummies
38
怦然心動的人生整理魔法
6
Computer Systems(Second Edition)
9
汽车修理工技能
2
世界上最温馨的50道心灵鸡汤
3
Practical Skills in Biomolecular Science
1
统计基础知识与统计实务 第2版
2
Practical Statistics for Field Biology
2
Henderson's Dictionary of Biological Terms
1
世界上最经典的品牌
4
Windows 7 All-in-One For Dummies
2
Readers Digest Write Better Speak Better
1
英语报刊佳作精选
1
Oracle Database 11g A Beginner's Guide
2
Oracle Database 11g初学者指南
11
Biology (5th Edition)
1
菜根谭
2
Microsoft SQL Server 2008 Internals (Pro - Developer)
1
零基础学SQL
7
希腊神话故事
1
21天学通Oracle
13
普斐特英语慢阅读
1
为什么偏偏是英国
2
Going Solo
1
了解英国
3
英语漫谈时事热点
5
World History
1
法国
2
Human Genetics
2
OCP
2
SQL查询凡人入门
4
?????:??????????
3
How to Read Novels Like a Professor
1
神雕侠侣
1
探索数码摄影的奥秘
1
Bioinformatics
2
Biochemistry
2
Excel实战入门
2
ChemOffice
1
软件测试
2
GRE阅读制胜法则
1
Excel/Access在数据与资料管理中的应用
1
Girl with a Pearl Earring
1
数据库系统导论
1
基督山伯爵(上下)
1
老外最想与你聊的100英语话题
1
探索式软件测试
2