Oracle PL/SQL: SQL*Plus Describe - Describe can be used in SQL*Plus to view tables, procedures, functions, packages.

Quick Search:

Oracle PL/SQL: SQL*Plus Describe

Jump to:

Category: >> Oracle PL/SQL >> SQL*Plus Describe

<< last

next >>

Snippet Name: SQL*Plus Describe

Description: Describe can be used in SQL*Plus to view tables, procedures, functions, packages.

Also see:
» SQL*Plus Configuration
» SQL*Plus SQL Prompt
» SQL*Plus Spool Command
» SQL*Plus Display commands
» SQL*Plus connect
» SQL*Plus formatting

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

CREATE OR REPLACE FUNCTION test1(stringin VARCHAR2) 
RETURN VARCHAR2 IS
BEGIN
  NULL; 
END test1;
/
describe test1
 
a shorter form IS TO USE 'desc'
 
 
CREATE OR REPLACE PROCEDURE test2(numbin NUMBER,
stringin IN OUT VARCHAR2, tfin OUT BOOLEAN)
BEGIN
  NULL; 
END test2;
/
 
DESC demoproc
 
 
Describe a TABLE -
 
DESC USER_TABLES
 
 
CREATE SYNONYM test3\/
 
DESC test3