oracle表操作语句

表语句使用：//新建一个表SQL> create table test_table(id number,name varchar2(20));

 

Name Type         Nullable Default Comments

ID   NUMBER       Y                        

 

email

Table altered

SQL> desc test_table;

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

NAME  VARCHAR2(20) Y                        

 

email

Table altered

SQL> desc test_table;

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

NAME VARCHAR2(20) Y                        

//插入两条记录SQL> insert into test_table (id,name) values(1,'ll');

SQL> insert into test_table (id,name) values(2,'ll');

 

 

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

         2 ll

//修改列的属性SQL> alter table test_table modify (name varchar2(30));

 

Name Type         Nullable Default Comments

ID   NUMBER       Y                        

 

Table altered

Table altered

SQL> desc test_table;

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

USER_NAME VARCHAR2(30) Y                        

//修改表的名字SQL> alter table test_table rename to table_test;

 

Name      Type         Nullable Default Comments

USER_ID   NUMBER       Y                        

 

 

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

         2 ll

//delete表，删除的是表中的数据，表还在SQL> delete table_test;

 

   USER_ID USER_NAME

 

Table dropped

SQL> select * from table_test;

select * from table_test

SQL>