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);