Notes

SQL*Plus: Release 11.2.0.2.0 Production on Wed Mar 4 04:22:49 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

SQL> connect u1806443
Enter password:
Connected.
SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BOOKS TABLE
DEPARTMENT TABLE
EMPLOYEE TABLE
ISSUE TABLE
RECEIVED TABLE
ROLLNO VIEW
ROLLONO VIEW
SALGRADE TABLE
ST1 TABLE
ST2 TABLE
STUD TABLE

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
STUDENTS TABLE

12 rows selected.

SQL> ed P1.sql

SQL> ed p1.sql

SQL> @p1
name='kiit';
*
ERROR at line 4:
ORA-06550: line 4, column 6:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
:= . ( @ % ;
The symbol ":= was inserted before "=" to continue.


SQL> @p1
name='kiit';
*
ERROR at line 4:
ORA-06550: line 4, column 6:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
:= . ( @ % ;
The symbol ":= was inserted before "=" to continue.


SQL> ed p1.sql

SQL> @p1

PL/SQL procedure successfully completed.

SQL> set serveroutput on;
SQL> @p1
kiit

PL/SQL procedure successfully completed.

SQL> ed p2.sql

SQL> @p2
SQL> @p2
SQL> ed p2.sql

SQL> @p2
SQL> ed p2.sql

SQL> @p2
sum =30

PL/SQL procedure successfully completed.

SQL> ed p3.sql

SQL> @p3
SQL> ed p3.sql

SQL> @p3
Enter value for a: 3
old 6: a:=&a;
new 6: a:=3;
Enter value for b: 5
old 7: b:=&b;
new 7: b:=5;
sum =8

PL/SQL procedure successfully completed.

SQL> ed p4.sql

SQL> @p4
Enter value for a: 5
old 5: a:=&a;
new 5: a:=5;
Enter value for b: 8
old 6: b:=&b;
new 6: b:=8;
dbms_output.put_line('max ='|| =b);
*
ERROR at line 13:
ORA-06550: line 13, column 34:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
( - + case mod new null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current max min prior sql stddev sum
variance execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively-quoted SQL
ORA-06550: line 15, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p4.sql

SQL> ed p4.sql

SQL> @p4
Enter value for a: 5
old 5: a:=&a;
new 5: a:=5;
Enter value for b: 8
old 6: b:=&b;
new 6: b:=8;
dbms_output.put_line('max ='|| =b);
*
ERROR at line 13:
ORA-06550: line 13, column 34:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
( - + case mod new null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current max min prior sql stddev sum
variance execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively-quoted SQL
ORA-06550: line 15, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p4.sql

SQL> @p4
Enter value for a: 5
old 5: a:=&a;
new 5: a:=5;
Enter value for b: 7
old 6: b:=&b;
new 6: b:=7;
end;
*
ERROR at line 15:
ORA-06550: line 15, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p4.sql

SQL> @p4
Enter value for a: 4
old 5: a:=&a;
new 5: a:=4;
Enter value for b: 8
old 6: b:=&b;
new 6: b:=8;
end;
*
ERROR at line 16:
ORA-06550: line 16, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p4.sql

SQL> @p4
Enter value for a: 6
old 5: a:=&a;
new 5: a:=6;
Enter value for b: 8
old 6: b:=&b;
new 6: b:=8;
end if;
*
ERROR at line 16:
ORA-06550: line 16, column 7:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:
( begin case declare end exit for goto if loop mod null
pragma raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge


SQL> ed p4.sql

SQL> @p4
Enter value for a: 5
old 5: a:=&a;
new 5: a:=5;
Enter value for b: 8
old 6: b:=&b;
new 6: b:=8;
end;
*
ERROR at line 16:
ORA-06550: line 16, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p4.sql

SQL> @p4
Enter value for a: 5
old 5: a:=&a;
new 5: a:=5;
Enter value for b: 6
old 6: b:=&b;
new 6: b:=6;
end;
*
ERROR at line 16:
ORA-06550: line 16, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p4.sql

SQL> @p4
Enter value for a: 5
old 5: a:=&a;
new 5: a:=5;
Enter value for b: 6
old 6: b:=&b;
new 6: b:=6;
max =6

PL/SQL procedure successfully completed.

SQL> ed p4.sql

SQL> ed p5.sql

SQL> ed p4.sql

SQL> ed p5.sql

SQL> @p5
Enter value for a: 5
old 4: a:=&a;
new 4: a:=5;
Enter value for b: 7
old 5: b:=&b;
new 5: b:=7;
end;
*
ERROR at line 12:
ORA-06550: line 12, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p5.sql

SQL> @p5
Enter value for a: 6
old 4: a:=&a;
new 4: a:=6;
end;
*
ERROR at line 11:
ORA-06550: line 11, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p5.sql

SQL> @p5
Enter value for a: 5
old 4: a:=&a;
new 4: a:=5;
end;
*
ERROR at line 12:
ORA-06550: line 12, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


SQL> ed p5.sql

SQL> @p5
Enter value for a: 5
old 4: a:=&a;
new 4: a:=5;
5 is positive

PL/SQL procedure successfully completed.

SQL> ed p5.sql

SQL> @p5
Enter value for a: 5
old 4: a:=&a;
new 4: a:=5;
5 is positive

PL/SQL procedure successfully completed.

SQL> @p5
Enter value for a: -9
old 4: a:=&a;
new 4: a:=-9;
-9 negative

PL/SQL procedure successfully completed.

SQL> ed p5.sql

SQL> @p5
Enter value for a: -9
old 4: a:=&a;
new 4: a:=-9;
-9 is negative

PL/SQL procedure successfully completed.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BOOKS TABLE
DEPARTMENT TABLE
EMPLOYEE TABLE
ISSUE TABLE
RECEIVED TABLE
ROLLNO VIEW
ROLLONO VIEW
SALGRADE TABLE
ST1 TABLE
ST2 TABLE
STUD TABLE

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
STUDENTS TABLE

12 rows selected.

SQL> select * stud;
select * stud
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected


SQL> select * from stud;

no rows selected

SQL> select * from st1;

NAME ROLL MARKS CGPA
---------- ---------- ---------- ----------
Pradeepta 50 159 6.23
Aman 51 259 7.23
Aman 52 269 7.29
Aman 53 279 8.29
Aasan 54 289 8.27
Basan 55 299 8.25
Balan 56 259 9.25
Byean 57 254 7.25
Cyean 58 274 4.25
Dyean 59 264 8.25

10 rows selected.

SQL> ed p6.sql

SQL> @p6
SQL> ed p6.sql

SQL> @p6
dbme_output.put_line(n);
*
ERROR at line 5:
ORA-06550: line 5, column 2:
PLS-00201: identifier 'DBME_OUTPUT.PUT_LINE' must be declared
ORA-06550: line 5, column 2:
PL/SQL: Statement ignored


SQL> ed p6.sql

SQL> @p6
Aman

PL/SQL procedure successfully completed.

SQL> ed p7.sql

SQL> @p7
Aman

PL/SQL procedure successfully completed.

SQL> ed p8.sql

SQL> @p8
select name into n from st1 where roll=51;
*
ERROR at line 4:
ORA-06550: line 4, column 21:
PL/SQL: ORA-00913: too many values
ORA-06550: line 4, column 2:
PL/SQL: SQL Statement ignored


SQL> ed p8.sql

SQL> ed p8.sql

SQL> @p8
Aman
51

PL/SQL procedure successfully completed.

SQL> ed p9.sql

SQL> @p9
Enter value for a: 6
old 5: a:=&a;
new 5: a:=6;
Enter value for b: 4
old 6: b:=&b;
new 6: b:=4;
6

PL/SQL procedure successfully completed.

SQL> @p9
Enter value for a: 4
old 5: a:=&a;
new 5: a:=4;
Enter value for b: 9
old 6: b:=&b;
new 6: b:=9;
4
5
6
7
8
9

PL/SQL procedure successfully completed.

SQL>