PLSQL Class 7 in Telugu |Parametric Cursor|where Current & for update |c...
Posts
Variable attributes, Flow control Statements
Ø Variable attributes 1. Column type variable Sname student.Sname%type; 2. Row type variable i student%rowtype; Ø CASE expression Declare V_dname varchar2(20); V_deptno number; Begin Select deptno into V_deptno from emp where empno=:p_empno; Case V_deptno When 10 then V_dname:=’Accounting’; When 20 then V_dname:=’RESEARCH’; When 30 then V_dname:=’SALES’; Else V_dname:=’UNKNOWN’; End case; Display(‘Emp department is ‘||V_dname); End; Ø Flow control statements 1. Conditional control statements ( if, if..else, i...
PL/SQL Class Notes 1-> Introduction , PLSQL Block structure,PLSQL Variables ,Banking Table creation,Nested Block, Labeled block
Pl/SQL Simple Notes Ø PL/SQL is a procedural language and which is extension to a non-procedural language SQL. It is a block structured language. PL/SQL tells how to do, SQL tells what to do. Ø A collection of Executable statements is called Block. Pl/SQL block is a logical collection of procedural and non-procedural statements. Ø Pl/SQL features § It is developed by oracle company in 1980’s. § It is used by only oracle whereas SQL can be used by any RDBMS, DBMS technologies. § It processes only one row at a time. § It supports executable block of statements at once. § It supports variables & Constraints, SQL-bind variables, PL/SQL bind and host variables. § It supports error handling. § It supports conditional statements (if, else, if-else). § It supports interaction controls (while loop, for loop….). § It supports sub-programs 1. ...