sqlplus
tnsping fails, but can connect to Oracle DB via sqlplus
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.[详细]
2023-03-26 19:03 分类：问答SqlPlus query issue (Package Spec and Body)
I am trying to get package spec and body from sqlplus by doing so.. select text fro开发者_StackOverflow社区m all_source[详细]
2023-03-26 13:17 分类：问答Oracle SQL*Plus ACCEPT Statements
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[详细]
2023-03-23 22:01 分类：问答Oracle SQLPlus question - writing strings to txt file
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[详细]
2023-03-22 06:00 分类：问答How to set the column width of the desc result in sqlplus?
Is t开发者_如何学JAVAhere any way to set the column width of the result of desc command in sqlplus?[详细]
2023-03-21 16:03 分类：问答Generate and insert large CLOB (1 MB) using SQL*Plus
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[详细]
2023-03-20 02:51 分类：问答How to execute SP with arguments 'table of foo'?
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\' ?[详细]
2023-03-18 22:54 分类：问答Oracle imp and exp commands
Normally when i have to take a backup of of a database on unix, i do, exp DBUSER/DBPSW@INST file=xxx.dmp[详细]
2023-03-17 18:26 分类：问答Inserting national characters into an oracle NCHAR or NVARCHAR column does not work
When inserting strings in an oracle database, some national characters are replaced with question marks, even though they are[详细]
2023-03-16 11:52 分类：问答sqlplus session read only
In sqlplus I can create a readonly transaction. set transaction read only; Is it possible to create a readonly session?[详细]
2023-03-15 03:15 分类：问答
加载中,请稍侯......