Oracle Database
文章平均质量分 65
lihongye_10
aim to be a java expert.
展开
-
修改Oracle SQL Developer的时间格式
打开Oracle SQL Developer, 选择 Tools --> Preferences --> Database --> NLS-->Date Format, 把默认的格式:DD-MON-RR 改为你想要的格式: 比如:显示完整的日期 将 ‘DD原创 2011-10-17 14:47:22 · 897 阅读 · 0 评论 -
用sqlplus 连接远程数据库, 执行.sql文件
1. Windows->Start-> cmd;2. Input : sqlplus username/password@hostname:port/SID;3. @file_name, 比如 将d:/test.sql 导入远程数据库,执行: @d:/test.sql;4. 如果test.sql中没有commit; 记得执行commit;5. 完成。原创 2011-10-31 10:56:21 · 5778 阅读 · 0 评论 -
oracle 分析函数之 over 用法
本文转载自: http://blog.csdn.net/mantisxf/article/details/1695441仅供个人学习提高使用。 Oracle 语法之 OVER (PARTITION BY ..)select * from test数据:A B C 1 1 1 1 2 2 1 3 3 2 2 5 3 4 6 ---将B列转载 2011-10-31 21:00:59 · 633 阅读 · 0 评论 -
Oracle Union
用于合并结果集,去掉重复记录table1 : code name c1 n1 c2 n2 table2 : code name c1 n1 c3 n3 select code , name from table1 union select转载 2011-10-27 21:03:56 · 472 阅读 · 0 评论 -
Oracle UNION ALL/UNION/INTERSECT/MINUS
OperatorDescriptionUNION ALLReturns all the rows retrieved by the queries, including duplicate rows.UNIONReturns all non-duplicate rows retrieved by the queries.INT转载 2011-11-15 23:12:27 · 632 阅读 · 0 评论 -
The execute sequence when using the WHERE and GROUP BY Clauses Together
The WHERE clause first filters the rows returned,then the remaining rows are grouped into blocks by the GROUP BY clause.原创 2011-10-25 20:50:31 · 444 阅读 · 0 评论 -
Oracle: Concatenate string
Prepare data: CREATE TABLE student ( "ID" VARCHAR2(4 BYTE) primary key, "FIRST_NAME" VARCHAR2(10 BYTE), "LAST_NAME" VARCHAR2(10 BYTE) ); Use the command 'describe student' to see原创 2011-10-23 14:41:08 · 1314 阅读 · 1 评论 -
oracle fuzzy inquery, using ignore case.
Here is an example: Prepare data:create table fruit( id number(4) primary key, name varchar2(150)); Insert into fruit(ID,NAME) values (1,'Apple');Insert into fruit (ID,NAME)原创 2011-10-23 14:11:11 · 740 阅读 · 0 评论 -
Oracle: Select constant as a column
Prepare data: CREATE TABLE fruit ( "ID" NUMBER(4,0), "NAME" VARCHAR2(50 BYTE), "PRICE" NUMBER(4,2) ) Insert into fruit (ID,NAME,PRICE) values (1,'Apple',1);Insert into f原创 2011-10-23 17:22:01 · 2118 阅读 · 0 评论 -
Oracle 子查询,按降序排列,取前n条
比如,有一个student 表: id student_name 1 s12 s203 s304原创 2011-10-23 16:40:20 · 9986 阅读 · 0 评论 -
Understanding basic database terminology
A database consists of tables and columns.Database Design TerminologyLogical/RelationalLogical/Object-OrientedPhysical ImplementationEntityClassTableAttri转载 2011-10-22 17:37:49 · 542 阅读 · 0 评论 -
Oracle backup one table to another table.
In Oracle, if you want to backup a table named table1 to another table named table1_backup,you can use the following SQL:create table table1_backup as select * from table1;原创 2011-10-22 16:43:13 · 986 阅读 · 0 评论 -
Oracle: Use NVL() to convert a null value into another value.
When you retrieve data from oracle database, when some records has null value in some columns,if you want to display the records more meaningful,with the columns whose value is原创 2011-10-22 16:25:24 · 600 阅读 · 0 评论 -
ORACLE中SQL运算符的优先级
SQL运算符优先级:优先级1 算术运算符2连接符3比较符4IS[NOT]NULL, LIKE, [NOT]IN5[NOT] BETWEEN6NOT7转载 2011-10-22 14:29:37 · 2196 阅读 · 0 评论 -
Understanding NUll values of Oracle
A NULL value in oracle database table is not representing a blank string, it means that the value for the column is unknown, when you select a column that contains a null value, you will see nothing i转载 2011-10-22 14:49:40 · 426 阅读 · 0 评论 -
Oracle: check the structure of a table
Oracle: check the structure of a table named test_table, just using the follwoing command: describe test_table; the output has 3 columns: the first column displays the column name of tabl原创 2011-10-22 12:29:27 · 1060 阅读 · 0 评论 -
Oracle/PLSQL: NVL Function
In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.The syntax for the NVL function is:NVL( string1, replace_with )string1 is the string to test fo转载 2011-11-06 20:37:31 · 593 阅读 · 0 评论