摘要： public static bool TestComand(string command, ref string outmessage) { string mypath = System.AppDomain.CurrentDomain.BaseDirectory; string parameter = " -help"; ... 阅读全文

摘要： -------------------------------------------------------------------------------- -- logicalschema.sql -- 1. Set initial preferences for the logicalschema instance -- 2.Install clean-up procedure for... 阅读全文

摘要： create directory mydir as 'c:\data' grant read,write on directory mydir to schemaname; export: expdp user/pass@db DIRECTORY=mydirectory schemas=schema 阅读全文

摘要： 快速 入门 使用 10046 事件 How to use 10046 event trace quickly?--author Eureka at 2013.06.06 第一步 使用sqlplus 连接Oracle服务器 1 Use tool Sqlplus connect to Oracle server. Such as Sqlplus username/password@db 第... 阅读全文

摘要： How to create table on another schema ? Question: we want to create table on anothere schema use different user; just like user a create table in user b. create user a identified by "pass" password... 阅读全文

摘要： clietn : socket class : config : 阅读全文

摘要： start xe by command (sqlplus) in my environment windows7 xe 10.2.0.1.0 Since there are Oracle 11 on my machine, so i use set command to set temp variable 1. Start lsnrctl.exe set ORACLE_SID=X... 阅读全文

摘要： ----------main.sql--------------------- spool main.log prompt --start main--; prompt ==============; prompt prompt ***start sub1.sql***; @@sub1.sql spool main.log append prompt ***end sub1.sql***; ... 阅读全文

摘要： 1 c:\Perl\bin\perl.exe findfile.pl #!/usr/perl/bin/perl ##C:\\MIG-WORK\\Research\\SPOOL\\main open(OFH, ">C:\\MIG-WORK\\Research\\SPOOL\\result.txt") || die("cna't open the file\n"); open(SOFH, ">C:... 阅读全文

摘要： Learn PL/SQL 1. How to use array(temp array) create table test_caseid (caseid RAW(16), userid NUMBER(9,0), activeflag NUMBER(9,0) DEFAULT 0); declare type array_t is varray(13) of NUMBER; --temp... 阅读全文