[{"title":"( 96 个子文件 587KB ) oracle pl/sql从入门到精通 配套源代码","children":[{"title":"本书源代码","children":[{"title":"Chp12","children":[{"title":"ErrorHandle.sql <span style='color:#111;'> 17.23KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp08","children":[{"title":"Record&Collection.sql <span style='color:#111;'> 25.65KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp03","children":[{"title":"explicitconvert.sql <span style='color:#111;'> 2.05KB </span>","children":null,"spread":false},{"title":"DateDemo.sql <span style='color:#111;'> 72B </span>","children":null,"spread":false},{"title":"VariableDefine1.sql <span style='color:#111;'> 381B </span>","children":null,"spread":false},{"title":"CHARDemo.sql <span style='color:#111;'> 926B </span>","children":null,"spread":false},{"title":"VariableValue.sql <span style='color:#111;'> 1.72KB </span>","children":null,"spread":false},{"title":"BooleanDemo.sql <span style='color:#111;'> 361B </span>","children":null,"spread":false},{"title":"rowidDemo.sql <span style='color:#111;'> 594B </span>","children":null,"spread":false},{"title":"VariableScope.sql <span style='color:#111;'> 613B </span>","children":null,"spread":false},{"title":"refcursorDemo.sql <span style='color:#111;'> 1.01KB </span>","children":null,"spread":false},{"title":"ConstantDemo.sql <span style='color:#111;'> 451B </span>","children":null,"spread":false},{"title":"INTERVALDemo.sql <span style='color:#111;'> 1.89KB </span>","children":null,"spread":false},{"title":"operatorexpress.sql <span style='color:#111;'> 3.38KB </span>","children":null,"spread":false},{"title":"NumberDemo.sql <span style='color:#111;'> 1.11KB </span>","children":null,"spread":false},{"title":"operatordemo.sql <span style='color:#111;'> 419B </span>","children":null,"spread":false},{"title":"timestamp.sql <span style='color:#111;'> 654B </span>","children":null,"spread":false},{"title":"ROWTYPEDemo.sql <span style='color:#111;'> 1.70KB </span>","children":null,"spread":false},{"title":"PlsInteger&BinaryInteger.sql <span style='color:#111;'> 669B </span>","children":null,"spread":false},{"title":"subtype.sql <span style='color:#111;'> 1.67KB </span>","children":null,"spread":false}],"spread":false},{"title":"Chp13","children":[{"title":"SubProgram.sql <span style='color:#111;'> 22.15KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp09","children":[{"title":"FunctionDemo.sql <span style='color:#111;'> 16.76KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp20","children":[{"title":"demo_base64.sql <span style='color:#111;'> 3.64KB </span>","children":null,"spread":false},{"title":"comm_email_lib.pkb <span style='color:#111;'> 41.17KB </span>","children":null,"spread":false},{"title":"DBMS_sql.pks <span style='color:#111;'> 1.79KB </span>","children":null,"spread":false},{"title":"Testing_Email_Body.pks <span style='color:#111;'> 4.27KB </span>","children":null,"spread":false},{"title":"comm_email_lib.pks <span style='color:#111;'> 10.29KB </span>","children":null,"spread":false},{"title":"CreateTableScript","children":[{"title":"rpt_tmp.sql <span style='color:#111;'> 4.58KB </span>","children":null,"spread":false},{"title":"CreateTable_emailList.sql <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"EMAIL_LIST.xls <span style='color:#111;'> 75.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"EmailTesting.pks <span style='color:#111;'> 3.07KB </span>","children":null,"spread":false},{"title":"SEND_MAIL.prc <span style='color:#111;'> 2.80KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp10","children":[{"title":"cursorDemo.sql <span style='color:#111;'> 20.14KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp17","children":[{"title":"OOP.sql <span style='color:#111;'> 25.20KB </span>","children":null,"spread":false},{"title":"ref.sql <span style='color:#111;'> 1.86KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp05","children":[{"title":"CheckConstraintDemo.sql <span style='color:#111;'> 4.47KB </span>","children":null,"spread":false},{"title":"FKConstraintDemo.sql <span style='color:#111;'> 530B </span>","children":null,"spread":false},{"title":"CreateTable1.sql <span style='color:#111;'> 5.43KB </span>","children":null,"spread":false},{"title":"Create as select.sql <span style='color:#111;'> 145B </span>","children":null,"spread":false},{"title":"IndexDemo.sql <span style='color:#111;'> 373B </span>","children":null,"spread":false},{"title":"IndexDemo2.sql <span style='color:#111;'> 588B </span>","children":null,"spread":false},{"title":"ViewDemo.sql <span style='color:#111;'> 2.73KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp01","children":[{"title":"002Sql.sql <span style='color:#111;'> 373B </span>","children":null,"spread":false},{"title":"001sql.sql <span style='color:#111;'> 2.56KB </span>","children":null,"spread":false},{"title":"VCINV_DEMO_01.sql <span style='color:#111;'> 493B </span>","children":null,"spread":false}],"spread":true},{"title":"Chp15","children":[{"title":"Tiggers.sql <span style='color:#111;'> 22.82KB </span>","children":null,"spread":false},{"title":"sqlnet.log <span style='color:#111;'> 953B </span>","children":null,"spread":false}],"spread":true},{"title":"Chp11","children":[{"title":"TransactionDemo.sql <span style='color:#111;'> 3.45KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp07","children":[{"title":"Insert.sql <span style='color:#111;'> 7.90KB </span>","children":null,"spread":false},{"title":"DMLOperation.sql <span style='color:#111;'> 9.97KB </span>","children":null,"spread":false}],"spread":true},{"title":"Chp19","children":[{"title":"Package.sql <span style='color:#111;'> 1.24KB </span>","children":null,"spread":false},{"title":"PackageBody.sql <span style='color:#111;'> 15.39KB </span>","children":null,"spread":false},{"title":"Scripts.sql <span style='color:#111;'> 4.92KB </span>","children":null,"spread":false},{"title":"Testing.sql <span style='color:#111;'> 1005B </span>","children":null,"spread":false},{"title":"Data","children":[{"title":"OS_IC_DEMAND_TEMP_DATA.xls <span style='color:#111;'> 115.00KB </span>","children":null,"spread":false},{"title":"IC_VENDOR_STOCK_TEMP_DATA.xls <span style='color:#111;'> 13.50KB </span>","children":null,"spread":false},{"title":"initdate.sql <span style='color:#111;'> 407B </span>","children":null,"spread":false},{"title":"OS_IC_SO_TEMP_DATA.xls <span style='color:#111;'> 81.50KB </span>","children":null,"spread":false},{"title":"OS_IC_SO_LISTS_TEMP_DATA.xls <span style='color:#111;'> 2.44MB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"Chp06","children":[{"title":"Initial.sql <span style='color:#111;'> 4.43KB </span>","children":null,"spread":false},{"title":"SimpleSELECT.sql <span style='color:#111;'> 9.50KB </span>","children":null,"spread":false}],"spread":false},{"title":"Chp16","children":[{"title":"DynamicSQL.sql <span style='color:#111;'> 16.22KB </span>","children":null,"spread":false}],"spread":false},{"title":"Chp14","children":[{"title":"Packages.sql <span style='color:#111;'> 28.55KB </span>","children":null,"spread":false}],"spread":false},{"title":"Chp04","children":[{"title":"ContinueDemo.sql <span style='color:#111;'> 1.22KB </span>","children":null,"spread":false},{"title":"NULLDemo2.sql <span style='color:#111;'> 716B </span>","children":null,"spread":false},{"title":"WHILELoopDemo.sql <span style='color:#111;'> 439B </span>","children":null,"spread":false},{"title":"LoopDemo.sql <span style='color:#111;'> 1003B </span>","children":null,"spread":false},{"title":"IFDemo.sql <span style='color:#111;'> 2.84KB </span>","children":null,"spread":false},{"title":"GOTOLabel.sql <span style='color:#111;'> 1.01KB </span>","children":null,"spread":false},{"title":"IFELSIFDemo.sql <span style='color:#111;'> 918B </span>","children":null,"spread":false},{"title":"NULLDemo.sql <span style='color:#111;'> 664B </span>","children":null,"spread":false},{"title":"FOR-LOOP.sql <span style='color:#111;'> 998B </span>","children":null,"spread":false},{"title":"SimpleCaseDemo.sql <span style='color:#111;'> 1.31KB </span>","children":null,"spread":false},{"title":"SearchedCASEDemo.sql <span style='color:#111;'> 784B </span>","children":null,"spread":false},{"title":"WhileLoopDemo2.sql <span style='color:#111;'> 352B </span>","children":null,"spread":false}],"spread":false},{"title":"Chp18","children":[{"title":"Performance.sql <span style='color:#111;'> 8.19KB </span>","children":null,"spread":false}],"spread":false},{"title":"Chp02","children":[{"title":"ObjectType.sql <span style='color:#111;'> 555B </span>","children":null,"spread":false},{"title":"CaseDemo.sql <span style='color:#111;'> 509B </span>","children":null,"spread":false},{"title":"TiggerDemo.sql <span style='color:#111;'> 1.24KB </span>","children":null,"spread":false},{"title":"DDLStatement.sql <span style='color:#111;'> 203B </span>","children":null,"spread":false},{"title":"LoopStructure.sql <span style='color:#111;'> 1.30KB </span>","children":null,"spread":false},{"title":"IfElse.sql <span style='color:#111;'> 815B </span>","children":null,"spread":false},{"title":"CreateFunction.sql <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"Exception1.sql <span style='color:#111;'> 389B </span>","children":null,"spread":false},{"title":"ProcedureDemo.sql <span style='color:#111;'> 323B </span>","children":null,"spread":false},{"title":"CollectionDemo.sql <span style='color:#111;'> 570B </span>","children":null,"spread":false},{"title":"PLSQLBlock1.sql <span style='color:#111;'> 213B </span>","children":null,"spread":false},{"title":"3SpaceIdentation.sql <span style='color:#111;'> 879B </span>","children":null,"spread":false},{"title":"CodeIdentifierDemo.sql <span style='color:#111;'> 141B </span>","children":null,"spread":false},{"title":"IdentifierDefine.sql <span style='color:#111;'> 598B </span>","children":null,"spread":false},{"title":"VariableDemo.sql <span style='color:#111;'> 416B </span>","children":null,"spread":false},{"title":"FORLoop.sql <span style='color:#111;'> 462B </span>","children":null,"spread":false},{"title":"RecordDemo.sql <span style='color:#111;'> 461B </span>","children":null,"spread":false},{"title":"DynamicSQL.sql <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"PackageDemo.sql <span style='color:#111;'> 1.68KB </span>","children":null,"spread":false},{"title":"Comments.sql <span style='color:#111;'> 304B </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":true}]