![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
ORACLE
文章平均质量分 81
jeanjeanfang
这个作者很懒,什么都没留下…
展开
-
SQL语句PART4
GRANT Name GRANT -- 定义访问权限 Synopsis GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] tablename [, ...] TO { usernam原创 2009-10-28 10:17:00 · 355 阅读 · 0 评论 -
需要进一步测试的内容
http://www.java2s.com/Tutorial/Oracle/CatalogOracle.htm ORACLE SQL SKILLS 1) TO DO TESTING:have, all, any, level, with(using), connect by 2) to check the meaning:IS INFINITE, IS NAN,原创 2010-01-23 20:44:00 · 475 阅读 · 0 评论 -
Import Utility Part2
Considerations When Importing Database Objects Importing Object Identifiers For object types, if IGNORE=y, the object type already exists, and the object identifiers, hashcodes, and type descri原创 2009-10-28 10:44:00 · 743 阅读 · 0 评论 -
SQL语句PART5
Confirming granted privilegesData Dictionary View DescriptionROLE_SYS_PRIVS System privileges granted to rolesROLE_TAB_PRIVS Table privileges granted to ro原创 2009-10-28 10:18:00 · 381 阅读 · 0 评论 -
Export Utility Part2
Example Export Session in User Mode User mode exports can be used to back up one or more database users. For example, a DBA may want to back up the tables of deleted users for a period of time. User原创 2009-10-28 10:50:00 · 882 阅读 · 0 评论 -
SQL语句PART6
Differring Constraints:Constraints can have the following attributes: DEFFERRABLE / NOT DEFFERRABLE, INITIALLY DEFFERRED / INITIALLY IMMEDIATE.e.g.:alter table dept2 add constraint dept2_id_pk primar原创 2009-10-28 10:21:00 · 490 阅读 · 0 评论 -
Export Utility Part1
What Is the Export Utility? An Export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in t原创 2009-10-28 10:46:00 · 557 阅读 · 0 评论 -
SQL语句PART10
oracle tips Exist的用法: select gw.ndocid from (select ndocid from wf_doc_gw_shouwen union select ndocid from wf_doc_gw_fawen) gw where not exists (select null from wf_doc_gw_sn sn where sn.nd原创 2009-10-28 10:28:00 · 304 阅读 · 0 评论 -
SQL语句PART1
Oracle SQL(partI) Data manipulation language(DML): select, insert, update, delete, merge.Data definition language(DDL): create, alter, drop, rename, truncate, commentData control language(DCL): gran原创 2009-10-28 10:01:00 · 484 阅读 · 0 评论 -
SQL语句PART11
1. My test: (create and grant the sysdba to a new user by SQL*Plus)CREATE USER FJTEST1 IDENTIFIED BY JEANJEANFANG;GRANT SYSDBA TO FJTEST;REVOKE SYSDBA FROM FJTEST;CONNECT FJTEST1/JEANJEANFANG AS SYSDB原创 2009-10-28 10:30:00 · 2029 阅读 · 0 评论 -
SQL语句PART9
Group functionsSELECT [column,] group_function(column) ... FROM table [WHERE condition] [GROUP BY group_by_expression] [ORDER BY column];e.g.:SELECT department_id, job_id, SUM(salary), COUNT(employee_原创 2009-10-28 10:25:00 · 319 阅读 · 0 评论 -
SQL语句PART8
PairWise subquery:e.g.:select * from wf_docsort where (ndocsortid,nmoduleinfoid) in (select ndocsortid, nmoduleinfoid from wf_docsort where instr(cname,文)>0)the above sql is the same function as:se原创 2009-10-28 10:24:00 · 384 阅读 · 0 评论 -
SQL语句PART7
Merge statementfunction benefits: 1) provides the ability to conditionally update, insert or delete data into a database table. 2) performs an update if the row exists, and an insert if it is a new ro原创 2009-10-28 10:22:00 · 398 阅读 · 0 评论 -
Oracle SQL实例
1。select * from a where a.rowid=(select min(b.rowid) from b where a.id=b.id);create test1(nflowid number primary key, ndocid number,drecvdate date); insert into test1 values (1, 12301, sys原创 2010-02-03 10:59:00 · 308 阅读 · 0 评论