Skip to content

Lawtec

Sections

Personal tools

Log in

You are here: Home → Members → antonh's Home → Articles → May2003 → Learning the Oracle Data Dictionary

Log in: Login Name

Password

Cookies are not enabled. You must enable cookies before you can log in.; Forgot your password?

News: Clear and rebuild Plone's portal_catalog 12-Jan-07; Plone and XML-RPC object creation 21-Sep-06; The state of the art in Plone AJAX support 21-Sep-06; M$ Outlook to Mail.app - Welcome to the Hotel California 07-Sep-06; Welcome to the new look Lawtec website 07-Sep-06; More news…

Licence

Creative Commons License

This work is licensed under a Creative Commons License.

Credits

Document Actions

Learning the Oracle Data Dictionary

by antonh — last modified 07-Sep-06 11:48 AM

I'm just learning Oracle, and just stumbled across the DESCRIBE statement which will tell you all about your table.

Eg.

DESCRIBE SCHEMA.table

gives you the name, type and whether it allows nulls for each column of your table.

This site conforms to the following standards: