I\'ve installed the Oracle Client v. 11.2.0.1 on a Windows XP machine and set both the TNS_ADMIN and ORACLE_HOME environment variables.
I am trying to get package spec and body from sqlplus by doing so.. select text fro开发者_StackOverflow社区m all_source
I need a bit of help with my SQL*Plus script. Is there any way I could have it so that it will accept a variable, check the table for a match and if it finds it exit the program and not continue with
I am attempting to write an sql command into an开发者_高级运维 sql file so that the output itself can be used as a script.Basically using a script to create output that is itself formatted into runnab
Is t开发者_如何学JAVAhere any way to set the column width of the result of desc command in sqlplus?
For test purposes, I would like to insert a large amount of data (a开发者_如何学JAVApprox. 1 MByte) into an Oracle CLOB column. In order to keep the test simple, I want to do that without having to wr
Using sqlplus how can I execute a stored procedure which has arguments which are \'table of foo\' ? So for instance in the following package how can I execute \'Get_AnnotationsForEmp\' ?
Normally when i have to take a backup of of a database on unix, i do, exp DBUSER/DBPSW@INST file=xxx.dmp
When inserting strings in an oracle database, some national characters are replaced with question marks, even though they are
In sqlplus I can create a readonly transaction. set transaction read only; Is it possible to create a readonly session?
加载中,请稍侯......