摘要：
1.sybase与oracle中insert into select和select into的用法http://wjlvivid.iteye.com/blog/1921679Sybase一、首先，我们来看一下insert into select语句 其语法形式为：Insert into Table... 阅读全文
摘要：
1.sybase 和 oracle 比较http://blog.itpub.net/14067/viewspace-1030014/Oracle采用多线索多进程体系结构Sybase采用单进程多线索体系结构Oracle和Sybase都采用多线索。采用多线索的模式，能用较少的线索管理大量的用户进程;并且... 阅读全文
摘要：
CursorsYou use a cursor to fetch rows returned by a query. You retrieve the rows into the cursor using aquery and then fetch the rows one at a time ... 阅读全文
摘要：
在sql developer中登陆某数据库,在procedure里面加入一个proc,种类选ARBOR:CREATE OR REPLACE PROCEDURE PROCEDURE23IS NAM VARCHAR2(100);BEGIN DBMS_OUTPUT.PUT_LINE('NAME:'||... 阅读全文
摘要：
FROM >dual is a table that contains a single row. The following outputfrom the DESCRIBE command shows the structure of the dual table, along with a qu... 阅读全文
摘要：
1.oracle for update和for update nowait的区别http://www.cnblogs.com/quanweiru/archive/2012/11/09/2762223.html首先一点，如果只是select的话，Oracle是不会加任何锁的，也就是Oracle对sel... 阅读全文
摘要：
A PL/SQL block has the following structure:[DECLAREdeclaration_statements]BEGINexecutable_statements[EXCEPTIONexception_handling_statements]END;/ []中... 阅读全文