RE: SQLPLUS training, why?
From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 27 Dec 2010 20:09:29 +0000
Message-ID: <FC2A9C4F46679142822F8EED6F30963302C4F1_at_ALVMBXW01.prod.quest.corp>
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.
Date: Mon, 27 Dec 2010 20:09:29 +0000
Message-ID: <FC2A9C4F46679142822F8EED6F30963302C4F1_at_ALVMBXW01.prod.quest.corp>
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?
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 27 2010 - 14:09:29 CST