(Subject Notes) Informatics Practices

Procedures Functions

PL/SQL provides packaging mechanism for small blocks of procedural code:

PROCEDURE ProcName(ArgList) IS
declarations;
BEGIN
statements;
EXCEPTION handlers;
END ProcName;

FUNCTION FuncName(ArgList) RETURN Type IS
declarations;
BEGIN
statements; -- including RETURN Expr;
EXCEPTION handlers;
END FuncName;

Each argument has a mode:

(Subject Notes) Informatics Practices

Transactions

 

A transaction is a sequence of SQL statements to accomplish a single task.

(Subject Notes) Informatics Practices

Exception Propagation

 

(Subject Notes) Informatics Practices

Tables

 

PL/SQl TABLEs combine characteristics of SQL tables and C/Pascal arrays.
Like SQL tables:

• consist of records (must have a numeric primary key)
• can grow/shrink as elements are added/removed

Exceptions

An exception is an unusual/erroneous condition encountered during execution:

(Subject Notes) Informatics Practices

Cursors

 

A cursor is a variable that can be used to access the result of a particular SQL query.

Cursors can move sequentially from row to row (cf. file pointers in C).

(Subject Notes) Informatics Practices

Iteration

 

LOOP
   Statements;
   ... EXIT ...
   MoreStatements;
END LOOP;

WHILE Cond LOOP
   Statements;
END LOOP;

FOR Var IN LoVal..HiVal LOOP
   Statements;
END LOOP;

 

(Subject Notes) Informatics Practices

PL/SQL

 

PL/SQL = Procedural Language extensions to SQL
An Oracle-specific language combining features of:

 

 

More Time Sought To Read Question Paper

Members of school teachers and principals’ associations in the State have requested the School Education Department to provide an additional 15 minutes for students taking the Standard X and XII Board examinations to help them go through the question paper carefully.

Detailed Syllabus English Lang. & Lit. Class IX 2008

ENGLISH - LANGUAGE AND LITERATURE
(Code No. 184)
Syllabus and Examination Specifications
CLASS IX

One Paper
Time: 3 Hours
Marks : 100

Detailed Syllabus English (Communicative) Class IX 2008

SYLLABUS AND EXAMINATION SPECIFICATIONS
English (Communicative)
(Code No. 101)
CLASS-IX
SEPARATE QUESTION PAPER AND ANSWER SHEET FORMAT REPLACES COMBINED BOOKLET FORMAT FROM MARCH, 2005 EXAMINATION.

One Paper 3 Hours 100 Marks

Detailed Syllabus Science and Technology Class IX 2008

COURSE STRUCTURE

CLASS IX (THEORY)
Science and Technology

One Paper Time : 2½ hours. Marks : 60