CREATE TABLE T_name (ID number,name varchar2 (Ten));d ROP Table T_name;select * FROM table_name where id = 2; INSERT INTO tabl E_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 ';--get code for created stored procedure select * from user_procedures;--query created stored procedure Show Error procedure procedure_name;--query stored procedure errors 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 Servero Utput on;set linesize 150;set pagesize 20;column c_01 format A20;
Review some of the basic statements used by Oracle