Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where is Desc <table> or conn <username>/<password> check

Re: Where is Desc <table> or conn <username>/<password> check

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 06 May 2006 20:39:33 +0200
Message-ID: <s9rp52d8gn2785e4s4qtv1o0298lrqh7rc@4ax.com>


On 6 May 2006 11:23:38 -0700, "peter" <hhh.database_at_gmail.com> wrote:

>Hello DBAs,
>
>I am a student OCP.
>I want to where does oracle check
>
>Desc <table> or conn <username>/<password>
>
>Do these entried go in Library Cache/Dictionary Cache or Data Buffer
>Cache or Redo Log Buffer Cache or in UGA
>and where does Oracle check validation on these entries.
>
>Why it accepts desc/descr/descri/describ <table>
>eventhough everything is for same purpose
>
>Can we give shortcuts like these in any user define query
>
>Pls help and send answer
>Thank You

both are sql*plus commands.
Please note the difference between SQL and sql*plus.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat May 06 2006 - 13:39:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US