Download CBSE Class 12 Informatics Practices Interacting With Databases Notes in PDF format. All Revision notes for Class 12 Informatics Practices have been designed as per the latest syllabus and updated chapters given in your textbook for Informatics Practices in Class 12. Our teachers have designed these concept notes for the benefit of Class 12 students. You should use these chapter wise notes for revision on daily basis. These study notes can also be used for learning each chapter and its important and difficult topics or revision just before your exams to help you get better scores in upcoming examinations, You can also use Printable notes for Class 12 Informatics Practices for faster revision of difficult topics and get higher rank. After reading these notes also refer to MCQ questions for Class 12 Informatics Practices given on studiestoday
Revision Notes for Class 12 Informatics Practices Interacting With Databases
Class 12 Informatics Practices students should refer to the following concepts and notes for Interacting With Databases in Class 12. These exam notes for Class 12 Informatics Practices will be very useful for upcoming class tests and examinations and help you to score good marks
Interacting With Databases Notes Class 12 Informatics Practices
CHAPTER-13
INTERACTING WITH DATABASES
Cursor is a method that provides a way to select multiple rows of data from the database and then process each row individually inside the PL/SQL program.
Types of Cursors :
♦ Implicit Cursor : Declared for all DML & PL/SQL SELECT statement including queries that return only one row.
♦ Explicit Cursor: For queries that return more than one row. Declared and named by programmer.
Explicit Cursor :
Following steps are followed when using the explicit cursor:
1. Declare the cursor.
2. Open the cursor.
3. Fetch the data from the cursor record by record.
4. Close the cursor.
Syntax for using cursor:
♦ Syntax of cursor declaration:
cursor
♦ Syntax of open statement:
open
♦ Syntax of fetch statement
fetch
or
fetch
♦ Syntax of close statement:
close
Explicit Cursor attributes:
There are four cursor attributes :
♦ %ISOPEN : It returns true if cursor is open , otherwise it returns false.
Syntax : if cursorname%isopen then
……….
else
……….
endif
♦ %FOUND : It returns true if record was fetched properly from the cursor, otherwise it returns false.
Syntax : cursorname%found
♦ %NOTFOUND : It returns true if record is not successfully found, otherwise it returns false.
Syntax : cursorname%notfound
♦ %ROWCOUNT : It returns the no. of records processed by the cursor.
Syntax : cursorname%rowcount
Example code to illustrate cursor:
DECLARE
cursor empdis is SELECT * FROM emp;
e emp%ROWTYPE;
BEGIN
open empdis;
if empdis%ISOPEN then
dbms_output.put_line(‘empno name salary’);
LOOP
FETCH empdis into e;
EXIT WHEN empdis%notfound;
dbms_output.put_line(e.empno|| e.name|| e.sal);
ENDLOOP;
CLOSE empdis;
else
dbms_output.put_line(‘Cannot open the cursor’);
END IF;
END;
Implicit Cursors:
These are also called as SQL cursors.
PL/SQL employs implicit cursors for following statements:
i. INSERT
ii. UPDTAE
iii. DELETE
iv. SELECT(only those SELECT queries that return exactly one row.)
Subqueries,IN WHERE clause,IN FROM clause, Aliases, Expressions,bind variables can be used with
Explicit cursors.
Cursor Based Records:
Cursor FOR Loops:
In a Cursor FOR Loop,a declared cursor is OPENed,FETCHed and CLOSed automatically.
Syntax:
FOR
LOOP
END LOOP;
Cursor FOR Loop with Parameters:
Syntax:
FOR
LOOP
.END LOOP;
Cursor FOR Loops Using Subqueries:
Syntax:
FOR
LOOP
.
END LOOP;
Please refer to attached file for CBSE Class 12 Informatics Practices Interacting with Databases study notes
More Study Material
CBSE Class 12 Informatics Practices Interacting With Databases Notes
We hope you liked the above notes for topic Interacting With Databases which has been designed as per the latest syllabus for Class 12 Informatics Practices released by CBSE. Students of Class 12 should download and practice the above notes for Class 12 Informatics Practices regularly. All revision notes have been designed for Informatics Practices by referring to the most important topics which the students should learn to get better marks in examinations. Studiestoday is the best website for Class 12 students to download all latest study material.
Notes for Informatics Practices CBSE Class 12 Interacting With Databases
Our team of expert teachers have referred to the NCERT book for Class 12 Informatics Practices to design the Informatics Practices Class 12 notes. If you read the concepts and revision notes for one chapter daily, students will get higher marks in Class 12 exams this year. Daily revision of Informatics Practices course notes and related study material will help you to have a better understanding of all concepts and also clear all your doubts. You can download all Revision notes for Class 12 Informatics Practices also from www.studiestoday.com absolutely free of cost in Pdf format. After reading the notes which have been developed as per the latest books also refer to the NCERT solutions for Class 12 Informatics Practices provided by our teachers
Interacting With Databases Notes for Informatics Practices CBSE Class 12
All revision class notes given above for Class 12 Informatics Practices have been developed as per the latest curriculum and books issued for the current academic year. The students of Class 12 can rest assured that the best teachers have designed the notes of Informatics Practices so that you are able to revise the entire syllabus if you download and read them carefully. We have also provided a lot of MCQ questions for Class 12 Informatics Practices in the notes so that you can learn the concepts and also solve questions relating to the topics. All study material for Class 12 Informatics Practices students have been given on studiestoday.
Interacting With Databases CBSE Class 12 Informatics Practices Notes
Regular notes reading helps to build a more comprehensive understanding of Interacting With Databases concepts. notes play a crucial role in understanding Interacting With Databases in CBSE Class 12. Students can download all the notes, worksheets, assignments, and practice papers of the same chapter in Class 12 Informatics Practices in Pdf format. You can print them or read them online on your computer or mobile.
Notes for CBSE Informatics Practices Class 12 Interacting With Databases
CBSE Class 12 Informatics Practices latest books have been used for writing the above notes. If you have exams then you should revise all concepts relating to Interacting With Databases by taking out a print and keeping them with you. We have also provided a lot of Worksheets for Class 12 Informatics Practices which you can use to further make yourself stronger in Informatics Practices
You can download notes for Class 12 Informatics Practices Interacting With Databases for latest academic session from StudiesToday.com
Yes, you can click on the link above and download notes PDFs for Class 12 Informatics Practices Interacting With Databases which you can use for daily revision
Yes, the notes issued for Class 12 Informatics Practices Interacting With Databases have been made available here for latest CBSE session
You can easily access the link above and download the Class 12 Notes for Informatics Practices Interacting With Databases for each topic in Pdf
There is no charge for the notes for CBSE Class 12 Informatics Practices Interacting With Databases, you can download everything free of charge
www.studiestoday.com is the best website from which you can download latest notes for Interacting With Databases Informatics Practices Class 12
Come to StudiesToday.com to get best quality topic wise notes for Class 12 Informatics Practices Interacting With Databases
We have provided all notes for each topic of Class 12 Informatics Practices Interacting With Databases as per latest CBSE syllabus