回顾Oracle几个用到的基本语句
create table t_name(id number,name varchar2(10)); drop table t_name; select * from table_name where id = 2 ; insert into table_name(c_01,c_02) values(1,'Terry'); update table_name set name = 'Tyron' where id = 1; delete from table_name where id = 3;
declare v_01 number(5,2); begin v_01 := 100/6; dbms_output.put_line(v_01);--16.67 end; /
select * from user_source where name ='procedure_name';--获取已创建存储过程的代码 select * from user_procedures;--查询已创建的存储过程 show error procedure procedure_name;--查询存储过程的错误 commit; rollback; select * from tab; describe tab_name; connect sys/123 as sysdba; alter user u_name account unlock; alter user u_name identified by 123; select * from v$nls_parameters; show user; set serveroutput on; set linesize 150; set pagesize 20; column c_01 format a20;