sqlplus
Describe in SQL*Plus - does it call a package or run SQL? (Or something else?)
When I describe开发者_C百科 an Oracle TYPE in SQL*Plus, what does SQL*Plus do \"under the bonnet\" - Is it calling DBMS_METADATA (or similar)?Or is it querying the data dictionary directly?[详细]
2023-04-13 03:48 分类：问答Formatting output of queries in SQLPlus
I\'m working with SQLPlus at the moment and whenever I query the Database, the result is in a complete mess. In other words, it is hard to read.I wonder if anyone knows how to format the output of que[详细]
2023-04-12 13:08 分类：问答what does the "2"mean in SQL*Plus?
I am new to Oracle. And I have come across a problem. Firstly,I want to check the privileges of the sysman account:[详细]
2023-04-11 22:05 分类：问答sqlplus - command line select statement doesn't use login.sql settings
I have an sh script containing this: sqlplus -S $JDBC_URL <<EOF $1; EOF That works fine.开发者_Python百科 However, it doesn\'t pick my formatting preferences from login.sql. Those settings wo[详细]
2023-04-11 07:32 分类：问答How to make a view not read only
I created a view that I make read only create view EMP_VU AS select ename employee_name, deptno, empno[详细]
2023-04-09 18:18 分类：问答Reading text file line by line in SQL*Plus
How to read a text file from Oracle SQL*plus? If there is a way to read from a bat file and pass the variable as a single line of text file, and simultaneously called from SQL*plus sql file, this op[详细]
2023-04-09 10:53 分类：问答spooling a clob value with multiple lines using sqlplus to a single cell of a CSV
I tried to spool a CLOB to a CSV file using code that looks like below: set pagesize 0 set heading off set long 30000[详细]
2023-04-09 03:44 分类：问答Need the settings of SQL developer "F5"
I need the settings in SQL Developer while performing the action Run as Script -f5. Since, if I use sqlplus. it is not giving the exact result format what I want. But, in SQL Developer gives the neede[详细]
2023-04-08 17:21 分类：问答Explanation of a BLOB and a CLOB
I am looking for a r开发者_JAVA技巧eal good explanation of a BLOB and CLOB data. I am looking for the great of that explains in plain English.BLOB\'s (Binary Large OBject) store binary files:pictures,[详细]
2023-04-08 09:32 分类：问答I see the error but the account is valid
SQL> CREATE or REPLACE FUNCTION custord (custNo IN number) 2RETURN NUMBER 3IS cust_tot NUMBER(11,2);[详细]
2023-04-06 23:51 分类：问答
加载中,请稍侯......