mysql show tables as_oracle中与mysql中的命令 show databases, show tables, desc table类似的命令集...

mysql> show tables

-> ;

+----------------+

| Tables_in_test |

+----------------+

| sale_report    |

| test_dysql     |

| union_tab_1    |

| union_tab_2    |

| v_sale_report  |

+----------------+

5 rows in set (0.00 sec)

Oracle 使用下面的语句实现

SQL> SELECT

2    table_name

3  FROM

4    all_tables

5  WHERE

6    ROWNUM < 10;

TABLE_NAME

------------------------------------------------------------

ICOL$

CON$

UNDO$

PROXY_ROLE_DATA$

FILE$

UET$

IND$

SEG$

COL$

9 rows selected.

mysql> desc sale_report;

+------------+---------------+------+-----+---------+-------+

| Field      | Type          | Null | Key | Default | Extra |

+------------+---------------+------+-----+---------+-------+

| SALE_DATE  | datetime      | NO   |     | NULL    |       |

| SALE_ITEM  | varchar(2)    | NO   |     | NULL    |       |

| SALE_MONEY | decimal(10,2) | NO   |     | NULL    |       |

+------------+---------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

Oracle

SQL> desc all_tab_columns

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

OWNER                                     NOT NULL VARCHAR2(30)

TABLE_NAME                                NOT NULL VARCHAR2(30)

COLUMN_NAME                               NOT NULL VARCHAR2(30)

DATA_TYPE                                          VARCHAR2(106)

DATA_TYPE_MOD                                      VARCHAR2(3)

DATA_TYPE_OWNER                                    VARCHAR2(30)