sqlplus
How can I remove trailing spaces & extra new line while spooling output?
Trailing spaces in the spooled output rpad(\' \',40)are getting truncated.If i remove the SET TRIMSPOOL on option the line size becomes 400 and there is a extra new line after each 开发者_开发百科sele[详细]
2023-03-12 12:31 分类：问答Shell script to email results of SQLPlus query using Mailx in AIX
I have the commands that I need. If I execute these commands at the prompt, everything works as expected. SQLPlus runs the query, exports the result to a file and then Mailx emails that file to me.[详细]
2023-03-11 19:02 分类：问答Oracle: Import CSV file
I\'ve开发者_如何转开发 been searching for a while now but can\'t seem to find answers so here goes...[详细]
2023-03-09 21:55 分类：问答Simulate Oracle SPOOL in Java
HI, I am converting a shell script to a Java program. The shell scripts runs an sql stat开发者_如何学JAVAement and spool the file to an external text file. I want to simulate this in Java. (The outpu[详细]
2023-03-09 16:12 分类：问答Oracle PL/SQL Analysing output of queries, writing to file
I\'m working on a project my boss gave me. I don\'t have much experience but I have to learn it. It\'s regarding Oracle DB 11g and I\'m using SQLPlus and PL/SQL as the query language.[详细]
2023-03-08 01:48 分类：问答SQL Plus vs Toad IDE - Running insert in SQL Plus takes significantly longer
I\'m running a query like this: INSERT INTO TableA (colA, colB) Select ColA, ColB from TableB This is huge insert, as it is querying over 2 million rows an then inserting them into the table.My qu[详细]
2023-03-07 20:56 分类：问答How do I get an sql*plus connection for the oracle 11db that I downloaded on my computer yesterday?
Okay, this is kinda infuriating. . . I can connect to开发者_开发问答 the oracle database on a server in another city but I can\'t connect to the oracle database on my own computer?What am I missing?Be[详细]
2023-03-07 18:31 分类：问答Oracle ODBC and SQL Plus
I am trying to create a new ODBC, I have added a new definition to the tnsnames, and tested the connection in SQl Plus.[详细]
2023-03-06 20:51 分类：问答Errors in my schema creation script
So I have a simple SQL script which creates a database schema of a simple library online catalog: DROP TABLE book_copies;[详细]
2023-02-28 22:22 分类：问答How do I complete the input of a CREATE TYPE in sqlplus (Oracle)?
I\'m trying to input a CREATE TYPE in my terminal, what I can\'t figure out how to finish it. Here is my specific query:[详细]
2023-02-28 14:28 分类：问答
加载中,请稍侯......