SQL commands

SQL*Plus: Release 8.1.5.0.0 - Production on Sat Sep 1 08:06:50 2007
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:Oracle8i Enterprise Edition Release 8.1.5.0.0 - ProductionWith the Partitioning and Java optionsPL/SQL Release 8.1.5.0.0 - Production
SQL> connect system/managerConnected.SQL> create user gaurav identified by gupta 2 /
User created.
SQL> grant connect,resource,dba to gaurav 2 /
Grant succeeded.
SQL> connect gaurav/guptaConnected.SQL> select * from emp;select * from emp *ERROR at line 1:ORA-00942: table or view does not exist
SQL> select * from tab;
no rows selected
SQL> create table emp 2 ( 3 empno number(4), 4 ename varchar(20). 5 SQL> edWrote file afiedt.buf
1 create table emp 2 ( 3 empno number(4), 4 ename varchar(20), 5 sal number(7,2) 6* )SQL> /
Table created.
SQL> insert into emp values(1001,'ankit Ji',23000) 2 /
1 row created.
SQL> edWrote file afiedt.buf
1* insert into emp values(1002,'Gaurav Ji',25000)SQL> /
1 row created.
SQL> edWrote file afiedt.buf
1* insert into emp values(1005,'abhi Ji',24000)SQL> /
1 row created.
SQL> edWrote file afiedt.buf
1* insert into emp values(1009,'anoop Ji',22000)SQL> /
1 row created.
SQL> commit 2 /
Commit complete.
SQL> select * from emp 2 /
EMPNO ENAME SAL--------- -------------------- --------- 1001 ankit Ji 23000 1002 Gaurav Ji 25000 1005 abhi Ji 24000 1009 anoop Ji 22000
SQL> select name from v$database 2 /
NAME---------ORCL
SQL> create or replace procedure mysal(x in number,s out number) 2 is 3 begin 4 select sal into s from emp where empno=x; 5 end; 6 /
Procedure created.
SQL> var a numberSQL> exec mysal(1002,:a)
PL/SQL procedure successfully completed.
SQL> print a
A--------- 25000
SQL> edWrote file afiedt.buf
1 create or replace procedure mysal1() 2 is 3 begin 4 update emp set sal=sal+sal*.3; 5* end;SQL> /
Warning: Procedure created with compilation errors.
SQL> edWrote file afiedt.buf
1 create or replace procedure mysal1 2 is 3 begin 4 update emp set sal=sal+sal*.3; 5* end;SQL> /
Procedure created.
SQL> select * from emp 2 /
EMPNO ENAME SAL--------- -------------------- --------- 1001 ankit Ji 23000 1002 Gaurav Ji 25000 1005 abhi Ji 24000 1009 anoop Ji 22000
SQL> exec mysal1
PL/SQL procedure successfully completed.
SQL> select * from emp 2 /
EMPNO ENAME SAL--------- -------------------- --------- 1001 ankit Ji 29900 1002 Gaurav Ji 32500 1005 abhi Ji 31200 1009 anoop Ji 28600
SQL> /
EMPNO ENAME SAL--------- -------------------- --------- 1001 ankit Ji 29900 1002 Gaurav Ji 32500 1005 abhi Ji 31200 1009 anoop Ji 28600
SQL> /
EMPNO ENAME SAL--------- -------------------- --------- 1001 ankit Ji 29900 1002 Gaurav Ji 32500 1005 abhi Ji 31200 1009 anoop Ji 28600
SQL> edWrote file afiedt.buf
1* select * from empSQL> edWrote file afiedt.buf
line 5 truncated. 1 create or replace procedure mysal1(x in number) 2 is 3 begin 4 update emp set sal=sal+x; 5* endSQL> /
Warning: Procedure created with compilation errors.
SQL> showerrorSP2-0042: unknown command "showerror" - rest of line ignored.SQL> show errorErrors for PROCEDURE MYSAL1:
LINE/COL ERROR-------- -----------------------------------------------------------------6/0 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; delete exists prior The symbol ";" was substituted for "end-of-file" to continue.
SQL> ed Wrote file afiedt.buf
1 create or replace procedure mysal1(x in number) 2 is 3 begin 4 update emp set sal=sal+x; 5* end;SQL> /
Procedure created.
SQL> select * FROM EMP 2 /
EMPNO ENAME SAL--------- -------------------- --------- 1001 ankit Ji 88397.39 1002 Gaurav Ji 95823.25 1005 abhi Ji 92110.32 1009 anoop Ji 84684.46
SQL>