如何在SQL中打印表的结构及其内容

I've created a simple database using Oracle SQL (iSQL plus). How can I print the table structure and its contents?

我使用Oracle SQL(iSQL plus)创建了一个简单的数据库。如何打印表结构及其内容?

2 个解决方案

#1

I know the desc command:

我知道desc命令:

http://www.riteshmandal.com/oracle.htm

DESC or DESCRIBE : Used to describe the table structure present in the tablespace.

DESC或DESCRIBE:用于描述表空间中存在的表结构。

USE : DESC e.g. DESC Employee;

使用:DESC,例如DESC员工;

USE : SELECT * FROM to view all the data inside the table. e.g. SELECT * FROM Employee

使用:SELECT * FROM查看表中的所有数据。例如SELECT * FROM Employee

Example:

SQL> -- create demo table
SQL> create table Employee(
  2    ID                 VARCHAR2(4 BYTE)         NOT NULL,
  3    First_Name         VARCHAR2(10 BYTE),
  4    Last_Name          VARCHAR2(10 BYTE),
  5    Start_Date         DATE,
  6    End_Date           DATE,
  7    Salary             Number(8,2),
  8    City               VARCHAR2(10 BYTE),
  9    Description        VARCHAR2(15 BYTE)
 10  )
 11  /

Table created.

SQL>
SQL> desc Employee;
 Name           Null?    Type
-------------------------------------------
 ID            NOT NULL   VARCHAR2(4)
 FIRST_NAME               VARCHAR2(10)
 LAST_NAME                VARCHAR2(10)
 START_DATE               DATE
 END_DATE                 DATE
 SALARY                   NUMBER(8,2)
 CITY                     VARCHAR2(10)
 DESCRIPTION              VARCHAR2(15)

SQL>
SQL>
SQL>
SQL> -- clean the table
SQL> drop table Employee
  2  /

Table dropped.

SQL>

#2

Two different queries will be used for this. The table to show the table structure is:

将使用两个不同的查询。显示表结构的表是:

describe <table_name>;
or
describe table <table_name>;

describe ;或描述表 ;

#1