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
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.
I\'ve开发者_如何转开发 been searching for a while now but can\'t seem to find answers so here goes...
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
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.
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
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
I am trying to create a new ODBC, I have added a new definition to the tnsnames, and tested the connection in SQl Plus.
So I have a simple SQL script which creates a database schema of a simple library online catalog: DROP TABLE book_copies;
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:
加载中,请稍侯......