Oracle Server Manager User's Guide

Contents Index Home Previous Next

DESCRIBE

Purpose

Describe a function, package, package body, procedure, table, or view.

Prerequisites

You must be currently connected to a database.

Syntax

DESCRIBE command ::=

where:

name The name of the object to describe.

Usage Notes

Procedures inside of packages cannot be described with this command.

Example

A command like 

DESCRIBE PROCEDURE scott.addemp

produces output similar to the following example: 

PROCEDURE SCOTT.ADDEMP (EMPNO INTEGER, ENAME VARCHAR2, SAL NUMBER(9,2))

Contents Index Home Previous Next