随笔分类 -  Oracle Utilities

摘要：The following example searches the string "CORPORATE FLOOR", beginning with the third character, for the string "OR". It returns the position in CORPORATE FLOOR at which the second occurrence of "OR" begins:SELECT INSTR('CORPORATE FLOOR','OR', 3, 2) &quo 阅读全文

摘要：ORACLE中常见的伪列的英文解释：官方网站:http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/06_ora.htm#1990SQL PseudocolumnsPL/SQL recognizes the following SQL pseudocolumns, which return specific data items: CURRVAL, LEVEL, NEXTVAL, ROWID, and ROWNUM. Pseudocolumns are not actual columns in a table but they behav 阅读全文

摘要：Oracle Row Generator Techniqueshttp://www.club-oracle.com/forums/row-generation-method-in-sql-also-in-pl-sql-t129/http://www.orafaq.com/wiki/Oracle_Row_Generator_Techniques早期使用----- select rownum from all_objects where rownum <xxx现在可以使用-----select rownum from dual connect by rownum<xxx或者----se 阅读全文