ORACLE基本语句

–新建表
create table T_TEST(
ID NUMBER PRIMARY KEY,
PHONE VARCHAR2(20),
PASS VARCHAR2(20),
CTIME DATE
);
–新增
insert into T_TEST values(
2,‘135’,‘000’,to_date(‘2021-07-02 11:00:00’,‘yyyy-MM-dd HH:mi:ss’));

–查询
select *from T_TEST where id=1;

–修改
update t_test set pass='88’where id=‘1’;
select *from T_TEST where id=1;

–删除
delete from t_test where id=‘1’;