随笔分类 -  Oracle

DBA说,什么优化,到系统上跑一跑就知道哪种写法好了
摘要:代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--/*test:Part_kit_Id14025426mdl_id:7743355pre-condition:inICAM,Wehaveequip_id=inventory_Id*/selectmdl_... 阅读全文

posted @ 2010-05-18 04:01 dolphin_bobo

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

posted @ 2010-05-17 16:51 dolphin_bobo

该文被密码保护。

posted @ 2010-05-17 03:59 dolphin_bobo

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

posted @ 2010-05-17 01:39 dolphin_bobo

存储过程常用技巧-相当基础也非常好
摘要:[代码]http://www.javaeye.com/topic/311176 阅读全文

posted @ 2009-07-01 17:16 dolphin_bobo

Oracle SQL 优化
摘要:[代码] 阅读全文

posted @ 2009-06-30 19:29 dolphin_bobo

中文ORACLE出现乱码
摘要:execute immediate 'alter session set nls_language=american';execute immediate 'alter session set nls_date_format=''MM/DD/YYYY''';---------- 阅读全文

posted @ 2009-05-19 00:20 dolphin_bobo

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

posted @ 2009-04-09 18:36 dolphin_bobo

Create User -esay way
摘要: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... 阅读全文

posted @ 2009-03-14 23:23 dolphin_bobo

Oracle登陆
摘要:默认用户 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就是主机字符串; ... 阅读全文

posted @ 2009-03-13 02:03 dolphin_bobo

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

posted @ 2009-03-13 01:51 dolphin_bobo

导航