sqlplus
sqlplus pass a string containing ' ' such as 'index1','index2','index3'
I need to pass this value to my sql file cause I am executing then a where condition with a IN. For instance : Delete FROM table WHERE col IN (\'index1\',\'index2\',\'index3\')[详细]
2023-01-25 13:40 分类：问答Equivalent of MySQL's \G in Oracle's SQL*Plus
In Oracle\'s SQL*Plus, the results of a SELECT are displayed in a tabular manner. Is there a way to display a row in a key-value manner (like MySQL\'s \\G option)?[详细]
2023-01-25 13:36 分类：问答How Can I Script Oracle Wallet Changes?
I use the Oracle wallet to store passwords for the databases I connect to.Our password policy requires us to change our passwords frequently enough that I would like to script the changes.I have a bat[详细]
2023-01-24 21:40 分类：问答Why is sql plus not including all of the data from my column with spool
I am using SQLPLUS to spool data out to a file, but not all of the data is being returned? I am using the dbms_metadata.get_ddl function and it is only returning part of the table definition to the fi[详细]
2023-01-24 10:49 分类：问答Generating SQL*Plus script using SQL*Plus
I want to generate a whole lot of SQL*Plus scripts by querying the data dictionary, but I\'m hitting some problems and suspect I\'m missing something obvious.[详细]
2023-01-24 02:46 分类：问答INSERT inside plsql procedure does not tell how many rows were inserted
i am trying to insert some rows 开发者_如何学编程and update some rows inside a pl/sqlloop. howeverall i get to see is the pl/sql procedure is successfully completed.[详细]
2023-01-24 02:12 分类：问答No way to execute SQL script from SQL Server Query Manager like @{file.sql} oracle sqlplus syntax?
Like the title says, in oracle you can issue the following command in SQL*Plus: SQL> select something from anothertable; #sql[详细]
2023-01-22 04:27 分类：问答Oracle SQLPlus setting environment variable based on variable
I want to set the environment var开发者_运维技巧iable long based on the size of the XML data I\'m trying to retrieve. The idea is something like this:[详细]
2023-01-21 07:04 分类：问答oracle query - ORA-01652: unable to extend temp segment but only in some versions of sql*plus
This one has me rather confused. I\'ve written a query which runs fine from my development client but fails on the production client with error \"ORA-01652: unable to extend temp segment by....\". In[详细]
2023-01-20 18:41 分类：问答Convert epoch to date in sqlplus / Oracle
I have the following table: SQL> desc recording NameNull?Type -------------------- -------- ------ CAPTUREIDNOT NULL NUMBER(9)[详细]
2023-01-18 13:56 分类：问答
加载中,请稍侯......