While connecting to db 开发者_开发百科[ oracle] using sqlplus in Unix, I don\'t want to display the contents like:
While running the SQL using sqlplus, I dodn\'t want to dispaly anything on the screen. I am using SPOOL to save the contents to a file. even if I redirect it dispaly开发者_开发知识库s connected to SQL
my question is that currently if i want to query for multiple开发者_开发问答 wildcarded values. I need to do something like this.
I\'m spooling out delimited text files from SQL*Plus, but every column is printed as the full size per its definition, rather than the data actually in that row.
How do I create a flat file with values fetched from a database ( using select ) i开发者_StackOverflown UNIX?If you\'re using SQLPlus, use the SPOOL directive to output script output to a file.This SO
I\'m trying to update a package in Oracle, coming from SQL Server this has been confusing. I have written a batch file that runs the .spec file first and the .body file second, but even running it ma
I have a directory full of PLSQL scripts that I want to run, the problem is that the content of that directory is dynamic, and I have no way to know what the names of those scripts will be.
I have a .sql file that has a sequence of create table statements, like this: crtab.sql define ll=\'&1\';
I am spooling from a sql script. when sql statement executes the variable substitution it displays it. how can i turn it off. it 开发者_如何学Pythondisplays the below along with the csv contents.
I have created a query block with begin/end and want to run that in SQL*Plus. But how can I run it in the command line?
加载中,请稍侯......