Answer: DESCRIBE command is used in Oracle.
By using this command we can see the structure of the table. In SQL Server, we use sp_help fpr the same purpose.
Example:
To describe a procedure called CUSTOMER_LOOKUP, enter
DESCRIBE customer_lookup
Output:
PROCEDURE customer_lookup
Argument Name Type In/Out Default?
---------------------- -------- -------- ---------
CUST_ID NUMBER IN
CUST_NAME VARCHAR2 OUT
Found interesting? Add this to: