RE: SQLPLUS training, why?

  • From: Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx>
  • To: 'Oracle L' <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Dec 2010 20:09:29 +0000

People seem to be talking about two different things here.
You definitely need to know the basis of Oracle SQL as mentioned in the SQL 
Reference manual.
http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/toc.htm
A DBA should know how to type in the commands related  to database 
administration, e.g. alter system, create tablespace, alter tablespace, create 
table, alter table, create index, alter index, etc. etc. And know where to go 
look if he doesn't remember the exact syntax to create a tablespace.

The question originally asked, as it seems to me, is this: does an Oracle DBA 
need  to know the SQL*Plus specific commands that you would use to create 
SQL*Plus reports, do variable substitution in SQL*Plus, etc? Does a DBA need to 
know what is in the SQL*Plus manual?
http://download.oracle.com/docs/cd/E11882_01/server.112/e16604/toc.htm

I vote yes, but how important is it to a DBA to know the SQL*Plus specific 
commands?

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2010