SQL> --learning about put_line and set serveroutput on SQL> begin 2 put_line('hello world'); 3 end; 4 / put_line('hello world'); * ERROR at line 2: ORA-06550: line 2, column 2: PLS-00201: identifier 'PUT_LINE' must be declared ORA-06550: line 2, column 2: PL/SQL: Statement ignored SQL> ed Wrote file afiedt.buf 1 begin 2 dbms_output.put_line('hello world'); 3* end; SQL> / PL/SQL procedure successfully completed. SQL> --the program was executed successfully SQL> run 1 begin 2 dbms_output.put_line('hello world'); 3* end; PL/SQL procedure successfully completed. SQL> set serveroutput on SQL> run 1 begin 2 dbms_output.put_line('hello world'); 3* end; hello world PL/SQL procedure successfully completed. SQL> begin 2 put_line('heascfbjhsdfgv'); 3 end; 4 / put_line('heascfbjhsdfgv'); * ERROR at line 2: ORA-06550: line 2, column 2: PLS-00201: identifier 'PUT_LINE' must be declared ORA-06550: line 2, column 2: PL/SQL: Statement ignored SQL> begin 2 dbms_output.put_line('hello world'); 3 end; 4 5 6 7 8 9 10 11 12 13 / hello world PL/SQL procedure successfully completed. SQL> begin 2 dbms_output.put_line(' 3 , 4 dfv 5 sdf 6 ed 7 ed 8 edıt 9 / ERROR: ORA-01756: quoted string not properly terminated SQL> begin 2 swdfdfsglkdb 3 dfgkdfjg 4 . SQL> ed Wrote file afiedt.buf 1 begin 2 swdfdfsglkdb 3* dfgkdfjg SQL> select * 2 from regions; REGION_ID REGION_NAME ---------- ------------------------- 1 Europe 2 Americas 3 Asia 4 Middle East and Africa SQL> select * 2 from regions 3 where id=1; where id=1 * ERROR at line 3: ORA-00904: "ID": invalid identifier SQL> ed Wrote file afiedt.buf 1 select * 2 from regions 3* where region_id=1 SQL> / REGION_ID REGION_NAME ---------- ------------------------- 1 Europe SQL> ed Wrote file afiedt.buf 1 select * 2 from regions 3* where region_id=&an_id SQL> / Enter value for an_id: 1 old 3: where region_id=&an_id new 3: where region_id=1 REGION_ID REGION_NAME ---------- ------------------------- 1 Europe SQL> / Enter value for an_id: 3 old 3: where region_id=&an_id new 3: where region_id=3 REGION_ID REGION_NAME ---------- ------------------------- 3 Asia SQL> ed Wrote file afiedt.buf 1 select * 2 from regions 3* where region_id=&an_id SQL> run 1 select * 2 from regions 3* where region_id=&an_id Enter value for an_id: 89 old 3: where region_id=&an_id new 3: where region_id=89 no rows selected SQL> ed Wrote file afiedt.buf 1 select * 2 from regions 3* where region_id=&ali SQL> / Enter value for ali: 1 old 3: where region_id=&ali new 3: where region_id=1 REGION_ID REGION_NAME ---------- ------------------------- 1 Europe SQL> ed Wrote file afiedt.buf 1 select * 2 from regions 3* where region_id=&xxxx SQL> / Enter value for xxxx: 3 old 3: where region_id=&xxxx new 3: where region_id=3 REGION_ID REGION_NAME ---------- ------------------------- 3 Asia SQL> select * 2 from &tablename; Enter value for tablename: regions old 2: from &tablename new 2: from regions REGION_ID REGION_NAME ---------- ------------------------- 1 Europe 2 Americas 3 Asia 4 Middle East and Africa SQL> ed Wrote file afiedt.buf 1 select * 2* from &1 SQL> / Enter value for 1: regions old 2: from &1 new 2: from regions REGION_ID REGION_NAME ---------- ------------------------- 1 Europe 2 Americas 3 Asia 4 Middle East and Africa SQL> ed Wrote file afiedt.buf 1 select &2 2* from &1 SQL> / Enter value for 2: * old 1: select &2 new 1: select * Enter value for 1: regions old 2: from &1 new 2: from regions REGION_ID REGION_NAME ---------- ------------------------- 1 Europe 2 Americas 3 Asia 4 Middle East and Africa SQL> --write a pl/sql program to print hello on screen SQL> ed Wrote file afiedt.buf 1 begin 2 dbms_output.put_line('hello'); 3* end; SQL> / hello PL/SQL procedure successfully completed. SQL> --decşare a varibale assign a name to it and print hello on screen SQL> ed Wrote file afiedt.buf 1 declare 2 name varchar2(10); 3 begin 4 name := 'ali'; 5 dbms_output.put_line('hello',name); 6* end; SQL> / dbms_output.put_line('hello',name); * ERROR at line 5: ORA-06550: line 5, column 2: PLS-00306: wrong number or types of arguments in call to 'PUT_LINE' ORA-06550: line 5, column 2: PL/SQL: Statement ignored SQL> ed Wrote file afiedt.buf 1 declare 2 name varchar2(10); 3 begin 4 name := 'ali'; 5 dbms_output.put_line('hello '||name); 6* end; SQL> / hello ali PL/SQL procedure successfully completed. SQL> --declare a variable for name, read the value from keyboard and print hello SQL> ed Wrote file afiedt.buf 1 declare 2 name varchar2(10); 3 begin 4 name := &your_name; 5 dbms_output.put_line('hello '||name); 6* end; SQL> / Enter value for your_name: 'nazife' old 4: name := &your_name; new 4: name := 'nazife'; hello nazife PL/SQL procedure successfully completed. SQL> / Enter value for your_name: omar old 4: name := &your_name; new 4: name := omar; name := omar; * ERROR at line 4: ORA-06550: line 4, column 11: PLS-00201: identifier 'OMAR' must be declared ORA-06550: line 4, column 2: PL/SQL: Statement ignored SQL> / Enter value for your_name: 'omar' old 4: name := &your_name; new 4: name := 'omar'; hello omar PL/SQL procedure successfully completed. SQL> ed Wrote file afiedt.buf 1 declare 2 name varchar2(10); 3 begin 4 name := '&your_name'; 5 dbms_output.put_line('hello '||name); 6* end; SQL> / Enter value for your_name: omar old 4: name := '&your_name'; new 4: name := 'omar'; hello omar PL/SQL procedure successfully completed. SQL> /*zdsfsdfsdf*/ Enter value for your_name: old 4: name := '&your_name'; new 4: name := ''; hello PL/SQL procedure successfully completed. SQL> rem write a program that reads a number from keyboard and prints too big if it is greater than 100 SQL> ed Wrote file afiedt.buf 1 declare 2 x number; 3 begin 4 x := &any_number; 5 if x>100 then 6 dbms_output.put_line('too big'); 7 end if; 8* end; 9 / Enter value for any_number: 400 old 4: x := &any_number; new 4: x := 400; too big PL/SQL procedure successfully completed. SQL> / Enter value for any_number: 6 old 4: x := &any_number; new 4: x := 6; PL/SQL procedure successfully completed. SQL> ed Wrote file afiedt.buf 1 declare 2 x number; 3 begin 4 x := &any_number; 5 if x>100 then 6 dbms_output.put_line('big number'); 7 else 8 dbms_output.put_line('small number'); 9 end if; 10* end; SQL> / Enter value for any_number: 789 old 4: x := &any_number; new 4: x := 789; big number PL/SQL procedure successfully completed. SQL> / Enter value for any_number: 56 old 4: x := &any_number; new 4: x := 56; small number PL/SQL procedure successfully completed. SQL> ed Wrote file afiedt.buf 1 declare 2 x number; 3 begin 4 x := &any_number; 5 if x>100 then 6 dbms_output.put_line('big number'); 7 elsif x>=0 then 8 dbms_output.put_line('small number'); 9 else 10 dbms_output.put_line('negative number'); 11 end if; 12* end; SQL> / Enter value for any_number: 45 old 4: x := &any_number; new 4: x := 45; small number PL/SQL procedure successfully completed. SQL> / Enter value for any_number: 456 old 4: x := &any_number; new 4: x := 456; big number PL/SQL procedure successfully completed. SQL> / Enter value for any_number: -5 old 4: x := &any_number; new 4: x := -5; negative number PL/SQL procedure successfully completed. SQL> spool off