回顧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;

declarev_01 number(5,2);beginv_01 := 100/6;dbms_output.put_line(v_01);--16.67end;/

　　

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;

　　

回顧Oracle幾個用到的基本語句