随笔分类 -  Oracle

摘要：代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--/*test:Part_kit_Id14025426mdl_id:7743355pre-condition:inICAM,Wehaveequip_id=inventory_Id*/selectmdl_... 阅读全文

摘要：代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--/*等价,相当于把每一条记录做为startwith来建立树必须有connectby,可以没有startwith*/selectCow,Bull,LPAD('',6*(Level-1))||Offspr... 阅读全文

该文被密码保护。

摘要：代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--createorreplaceprocedureput_line_unlimit(p_stringinlong)isl_stringlongdefaultp_string;beginloopexitw... 阅读全文

摘要：[代码]http://www.javaeye.com/topic/311176 阅读全文

摘要：[代码] 阅读全文

摘要：execute immediate 'alter session set nls_language=american';execute immediate 'alter session set nls_date_format=''MM/DD/YYYY''';---------- 阅读全文

摘要：CodeCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->declare -- result cursor token varchar2(2) := '@'; cursor c_regin is select nm_customer, ... 阅读全文

摘要：Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->-- Create the user create user CHNICAM identified by CHNICAM; -- Grant/Revoke role privilege... 阅读全文

摘要：默认用户 SYS: change_on_install SYSTEM:manager －－－－－－－－－ SQLPLUS 登陆 1、在windows服务启动oracle相关服务器； 2、在xp的命令行用“sqlplus /nolog”登录后以sysdba连接数据库（"conn /as sysdba")； 3、用“select name from v$database;”的name就是主机字符串； ... 阅读全文

摘要：Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SELECT ATC.TABLE_NAME, ATC.COLUMN_NAME, DECODE(ATC.DATA_TYPE, 'NUMB... 阅读全文