1. 查看表结构
SQL>desc <表名>
例:
SQL> desc tbtest
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(6)
2.返回所有表
SQL> select table_name from all_tables;
3.返回当前用户的所有表(1)
SQL> select table_name from user_tables;
或者
SQL> select table_name from tabs;
4.查询数据库SID
SQL> select instance_name from v$instance;
5. 查看数据库里面所有用户,前提是你是有dba权限的帐号,如sys,system
SQL> select * from dba_users;
6. 查看你能管理的所有用户
SQL> select * from all_users;
7. 查看当前用户信息
SQL> select * from user_users;
8. 查看数据库名
SQL> select name from v$database;
9.查看实例名
SQL> select instance_name from v$instance;
10. 显示表结构
SQL> desc <table_name>;
例如:
SQL> desc IT_EMPLOYEES;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
JOB_ID VARCHAR2(10)
SALARY NUMBER(8,2)
MANAGER_ID NUMBER(6)
11. 查看表里的所有记录
SQL> select * from <table_name>;
例如:
SQL> select * from IT_EMPLOYEES;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER JOB_ID SALARY MANAGER_ID
------------------------- -------------------- ---------- ---------- ----------
1 Make
13856734577 9567
12. 显示当前用户
SQL> show user
13. 查询序列(sequence)
SQL>desc <表名>
例:
SQL> desc tbtest
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(6)
2.返回所有表
SQL> select table_name from all_tables;
3.返回当前用户的所有表(1)
SQL> select table_name from user_tables;
或者
SQL> select table_name from tabs;
4.查询数据库SID
SQL> select instance_name from v$instance;
5. 查看数据库里面所有用户,前提是你是有dba权限的帐号,如sys,system
SQL> select * from dba_users;
6. 查看你能管理的所有用户
SQL> select * from all_users;
7. 查看当前用户信息
SQL> select * from user_users;
8. 查看数据库名
SQL> select name from v$database;
9.查看实例名
SQL> select instance_name from v$instance;
10. 显示表结构
SQL> desc <table_name>;
例如:
SQL> desc IT_EMPLOYEES;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
JOB_ID VARCHAR2(10)
SALARY NUMBER(8,2)
MANAGER_ID NUMBER(6)
11. 查看表里的所有记录
SQL> select * from <table_name>;
例如:
SQL> select * from IT_EMPLOYEES;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER JOB_ID SALARY MANAGER_ID
------------------------- -------------------- ---------- ---------- ----------
1 Make
13856734577 9567
12. 显示当前用户
SQL> show user
13. 查询序列(sequence)
SQL>select sequence_name from user_sequences;
13. 查询触发器(trigger)
SQL> select trigger_name from user_triggers;
14. 创建一个表 TABLETEST2
SQL> CREATE TABLE TABLETEST
2 (
3 NO NUMBER(10,0) not null unique,
4 NUMONE NUMBER(6,0) not null unique,
5 NUMTWO NUMBER(6,0) not null);