Question : I know the question might sound too stupid, but I never understood this part. SQL*Plus works with both […]
Tag: sqlplus
Is there a setting to suppress C-Style comments appearing as DOC in Oracle Output?
Question : Just again looking at some log from an oracle script, where the developer intended to comment out some […]
Create new control files using SQLPLUS
Question : down vote favorite I need help with creating controlfile using sqlplus. I have used next steps, I altered […]
SQL Spool FILE SQLPLUS BATCH FILE
Question : */ SET colsep ‘;’ SET TERMOUT OFF SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 800 SET PAGESIZE […]
Can’t connect to a Oracle db instance via SQLDeveloper
Question : When I set the connecting information on the GUI in SQLDeveloper I get the following error (everytime!) Status […]
IF condition in connect command in SQL*Plus
Question : I want to fire SQL queries only when the user is connected to SQL*Plus. In my case even […]
Comfortable sqlplus interface?
Question : I found sqlplus‘interface is rather outdated. It’s quite nice to have some commands or keywords at disposal, but […]
“ORA-02270: no matching unique or primary key for this column-list” on table creation [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Differences with using Bind variables in TOAD,sqlplus and SqlDeveloper
Question : I have following example query. variable pStartDateBegin VARCHAR2(10); variable pEndDateFinish VARCHAR2(10); begin select ’01-01-2000′, ’30-11-2011′ into :pStartDateBegin,:pEndDateFinish from […]
SQLPlus Padding in Query Results
Question : I have several Oracle servers that exhibit a behavior I do not understand. I have identified a two […]