sqlplus
How do you set linesize, pagesize, and other environment parameters permanently in Oracle 10g?
how to set linesize, pagesize pe开发者_运维知识库rmanently in oracle 10g?Is this for SQL*Plus? If so, these instructions will work:[详细]
2023-02-10 13:03 分类：问答Detect sqlplus error in dos batch script?
We have the following batch script: ( echo @release.sql echo exit ) | sqlplus x/y@orcl if %errorlevel% gtr 1开发者_Go百科 goto dberror[详细]
2023-02-09 21:23 分类：问答How to store result from SQLPlus to a shell variable
My requirement is to store the result of an sqlplus operation into a variable in my shell script. I need the result of the following operation which is in my .sh file[详细]
2023-02-09 10:13 分类：问答Open a piped process (sqlplus) in perl and get information from the query?
Basically, I\'d like to open a pipe to sqlplus using Perl, sending a query and then getting back the information from the query.[详细]
2023-02-08 21:26 分类：问答Simple Oracle query: literal does not match format string
I want to execute a simple function in Oracle. The signature is de开发者_运维问答fined as follows:[详细]
2023-02-08 01:49 分类：问答Why does SQLPLUS show empty and null CLOBs as null?
It seems SQLPLUS shows nulls and empty strings for CLOBs in a way that I wasn\'t expecting. Try the following in SQLPLUS (I\'m using Oracle 10g Server). Create a table with a CLOB, and insert null, e[详细]
2023-02-07 14:03 分类：问答SQLPlus export to CSV (output format problem)
I\'m facing an issue with an interface script, supposed to export the content of some table of an ORACLE database into CSV file, which is then followed by an import of those CSV into a MYSQL database.[详细]
2023-02-07 00:58 分类：问答Oracle 11g R2 SE run query
How do i run the below query inside sql > prompt in Oracle 11g R2 SE CREATE TRIGGER \"ICD\".TR_DEL_SYSTEMALERTCFG_CSTLVL[详细]
2023-02-06 16:40 分类：问答Oracle sqlplus HTML report - alternating rows color
I use Oracle sqlplus \"set markup html on\" to quickly convert query output into HTML report - It\'s very simlpe way to publish database report online.[详细]
2023-02-06 08:25 分类：问答How to display to terminal in SQLPLUS the column of a row with the width of the max value of the data within that column
I was wondering if this could be done without the COLUMN FORMAT. Current example: TABLESPACE_NAMEBIG DATAFILE_NAME[详细]
2023-02-05 14:54 分类：问答
加载中,请稍侯......