Query method: 1. Use cmd to log in to the user account and connect to the oracle database; 2. Use the "desc table name" command to get the design structure and table type of the specified table. desc can be used as a keyword for descending and ascending order, and can also be used with the table name to display the detailed fields of the table.
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
The first step is to log in to the user account through cmd and the environment
The second step: use desc(description) table to get the table The design structure and data type
are shown in the figure below:
desc is used as the keyword for descending sorting
desc table name: display the detailed fields of the table
The example is as follows:
Recommended tutorial: "Oracle Video Tutorial"
The above is the detailed content of How to query the table structure with desc in oracle. For more information, please follow other related articles on the PHP Chinese website!
