sqlplus
Suppress the contents of the SQLplus command in UNIX?
While connecting to db 开发者_开发百科[ oracle] using sqlplus in Unix, I don\'t want to display the contents like:[详细]
2023-02-04 14:40 分类：问答Running a SQL using sqlplus in UNIX?
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[详细]
2023-02-04 14:36 分类：问答How to use LIKE statement in sql plus with multiple wild carded values?
my question is that currently if i want to query for multiple开发者_开发问答 wildcarded values. I need to do something like this.[详细]
2023-02-03 03:34 分类：问答Showing only actual column data in SQL*Plus
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.[详细]
2023-01-31 17:00 分类：问答How do I create a flat file with values fetched from a database in UNIX?
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[详细]
2023-01-30 20:53 分类：问答Update a package from SQLPLUS
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[详细]
2023-01-30 03:11 分类：问答Call plsql script within another plsql script
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.[详细]
2023-01-26 21:55 分类：问答How can I execute only selective statements from a SQL file?
I have a .sql file that has a sequence of create table statements, like this: crtab.sql define ll=\'&1\';[详细]
2023-01-26 05:31 分类：问答Regarding SQLl*Plus set statements
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.[详细]
2023-01-25 17:52 分类：问答How to run Oracle query with begin/end in SQL*Plus?
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?[详细]
2023-01-25 16:52 分类：问答
加载中,请稍侯......