Showing posts with label sqlplus. Show all posts
Showing posts with label sqlplus. Show all posts
Tuesday, 25 July 2017

SQL PLUS system parameters usage (set/show)

›
To show parameter in detail SQL> SHOW DEFINE; To escape from substitution variable (&): SQL> SET DEFINE OFF; To enable DBMS_...
Monday, 8 May 2017

How to know $ORACLE_HOME path via sqlplus in Windows ?

›
CMD> sqlplus  / as sysdba SQL>  set serveroutput on; SQL> DECLARE  Result_Val VARCHAR2(100); BEGIN   dbms_system.get_env(...
Monday, 9 January 2017

How to configure display format of sqlplus ?

›
e.g. set linesize 200 set pagesize 100 column object_name  format a30 column object_type  format a106 -- optional column owner format ...
Tuesday, 13 September 2016

How to define new db link?

›
Add a new connection node into tnsnames.ora file. vi $ORACLE_HOME/network/admin/tnsnames.ora e.g. ALPER_DB =   (DESCRIPTION =     (...
Friday, 10 June 2016

How to use sqlcl?

›
Recently, Oracle announced that we have a new SQL Plus command line anymore! Its name is sqlcl that seems to very useful and powerful tool....
Saturday, 31 October 2015

How to login without any connection in sqlplus?

›
CMD> sqlplus /nolog SQL> conn hr/hr - nolog parameter is using for just entering to sqlplus
Monday, 2 February 2015

How to know the current connected user in sqlplus?

›
SQL> SHOW USER; USER is "ALPER"
Sunday, 19 October 2014

How to run .sql file in sqlplus?

›
Press Windows button + R and press cmd then click "OK". Write down "below command" and press enter Full path approa...
Wednesday, 15 October 2014

How to clear screen in sqlplus?

›
SQL> clear screen;
Friday, 10 October 2014

How to login sqlplus on linux command window in Linux?

›
$ sqlplus scott/tiger @orcl @orc1 ->  tnsnames.ora – connection node name scott -> db username tiger -> db username password  ...