摘要:
CASE111. SQL脚本[oracle@node3 ulcase]$ cat ulcase11.sqlset termout offrem host write sys$output "Building demonstration tables for case study 11. Pleas... 阅读全文
摘要:
CASE101. SQL脚本[oracle@node3 ulcase]$ cat ulcase10.sqlrem host write sys$output "Building case 10 demonstration tables. Please wait"rem do all cleanup... 阅读全文
摘要:
CASE91. SQL脚本[oracle@node3 ulcase]$ cat ulcase9.sqlset termout offrem host write sys$output "Building case 9 demonstration tables. Please wait"drop t... 阅读全文
摘要:
CASE81. SQL脚本[oracle@node3 ulcase]$ cat ulcase8.sqlset termout offrem host write sys$output "Building case 8 demonstration tables. Please wait"drop t... 阅读全文
摘要:
CASE71. SQL脚本case7包含两个SQL脚本,一个是删除脚本ulcase7e.sql,一个是创建脚本ulcase7s.sql[oracle@node3 ulcase]$ cat ulcase7e.sqlset termout offrem host write sys$output "Cl... 阅读全文
摘要:
CASE61. SQL脚本[oracle@node3 ulcase]$ cat ulcase6.sqlset termout offrem host write sys$output "Building case 6 demonstration tables. Please wait"drop t... 阅读全文
摘要:
CASE51. SQL脚本[oracle@node3 ulcase]$ cat ulcase5.sqlset termout offrem host write sys$output "Building case 5 demonstration tables. Please wait"drop t... 阅读全文
摘要:
CASE41. SQL脚本[oracle@node3 ulcase]$ cat ulcase4.sqlset termout offrem host write sys$output "Building case 4 demonstration tables. Please wait"drop t... 阅读全文
摘要:
CASE31. SQL文件[oracle@node3 ulcase]$ cat ulcase3.sqlset termout offrem Do not clean up table because this example shows appending to existingrem rows i... 阅读全文
摘要:
CASE21. 控制文件[oracle@node3 ulcase]$ cat ulcase2.ctl-- NAME-- ulcase2.ctl - SQL*Loader Case Study 2: Loading Fixed-Format Files---- DESCRIPTION-- This c... 阅读全文
摘要:
最近项目涉及到将文本文件中的数据导入到Oracle数据库中,故研究了下SQL*Loader,官档提供的资料不是很丰富,很多案例中出现的语句在官档中找不到出处。但它提供的案例本身却彰显出了SQL*Loader功能的强大。鉴于Oracle 11g的软件本身没有携带这些案例,需要专门到官方网站下载Oracle Database 11g Release 2 Examples,甚是麻烦。在此,将这些案例分享,也方便以后研究、借鉴。 阅读全文