sqlplus
DEFINE_EDITOR=vi in sql*plus
After doingDEFINE_EDITOR=vi . I wrote SQL > edit samp开发者_Go百科le.sql This is being stored in Jagan/Documents by default. But i want this to be stored in Jagan/Documents/plsql. Can anybody t[详细]
2023-01-15 18:08 分类：问答How to access help pages from SQL*Plus prompt?
Does SQLPlus provide the help pages for its commands? Is there a way to access the help text from the 开发者_C百科SQLPlus prompt, like this text for STARTUP?[详细]
2023-01-15 08:29 分类：问答Oracle SQLPlus: Underline format when computing sum on multiple columns
I am computing the sum of multiple columns on the same break, but the output only displays a dash (-) underline between the last record and the column totals for a single column only...and it appears[详细]
2023-01-15 07:08 分类：问答SQLPlus command line script hangs when inserting records
Using sqlplus 11g on windows to run sql script on 11g database. Sqlplus hangs if insert line left in script. If I comment out the insert line, the script returns the records.[详细]
2023-01-14 12:35 分类：问答Oracle query execution time
I would like to get the 开发者_运维知识库query execution time in Oracle. I don\'t want the time Oracle needs to print the results - just the execution time.[详细]
2023-01-12 18:15 分类：问答How can I organize tables in SQL*Plus?
I am practicing SQL, and suddenly I have so many tables. What开发者_开发知识库 is a good way to organize them? Is there a way to put them into different directories?[详细]
2023-01-12 01:34 分类：问答SQL*Plus history under Linux
How to make sqlplus in Linux to maintain history of my queries? So that I co开发者_运维问答uld use up/down arrows to get my previous query.rlwrap package is needed. Used like this:[详细]
2023-01-11 15:17 分类：问答Is there an equivalent of less for SQL*Plus?
Sometimes a query on SQL*Plus might yield too many rows t fit on the screen. Is there some equivalent of \"piping to less/more\" mechanism that I can do to navigate the res开发者_运维技巧ults?[详细]
2023-01-11 09:02 分类：问答Does SQL*Plus natively allow queries to run from the shell itself?
For example, is there equivalent of these in SQ开发者_如何学CL*Plus sqlplus \'SELECT * FROM emp\' | less[详细]
2023-01-10 19:15 分类：问答Why Oracle Sql*Plus print many unneeded heading?
When I run a sql statement w开发者_Go百科hich supposed to return exact one row, sqlplus print column names many many times ? why ?Probably because your pagesize is much smaller than the number of line[详细]
2023-01-06 15:39 分类：问答
加载中,请稍侯......