Oracle笔记

查询

查看当前用户名

select user from dual;

查看表空间

Select * From dba_tablespaces;

查看某用户的所有表

select TABLE_NAME from all_tables where owner = 'SYSTEM';

查看当前用户的所有表

select TABLE_NAME from user_tables;

查看数据所有表

select * from tab;

DML

INSERT INTO tb_user VALUES (1,'haha');
select * from TB_USER;

DDL

CREATE TABLE tb_user(id INT PRIMARY key,name VARCHAR(128) not null);