Scribd
Upload
4 views1 page

Oracle Database and PL/SQL Essentials

The document discusses various Oracle database concepts including how to drop and add rows to tables, sorting data, set operators, nested subqueries, the structure of PL/SQL blocks, data manipulation in PL/SQL, exceptions and exception types, PL/SQL VARRAYs, constraints and their types, altering tables, built-in functions, restricting data with the WHERE clause, joins, views, control structures in PL/SQL, variables and anchored declarations, cursors, PL/SQL records, and PL/SQL tables.

Uploaded by

Jijo Kumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views1 page

Oracle Database and PL/SQL Essentials

The document discusses various Oracle database concepts including how to drop and add rows to tables, sorting data, set operators, nested subqueries, the structure of PL/SQL blocks, data manipulation in PL/SQL, exceptions and exception types, PL/SQL VARRAYs, constraints and their types, altering tables, built-in functions, restricting data with the WHERE clause, joins, views, control structures in PL/SQL, variables and anchored declarations, cursors, PL/SQL records, and PL/SQL tables.

Uploaded by

Jijo Kumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Part-B

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Discuss on oracle client/server databases. How to drop a table in Oracle? Explain how to add a new Row/Record? Explain about sorting? Discuss about Set operators with example? Explain SQL nested sub queries. Give the block structure of PL/SQL? How data manipulation done in PL/SQL? Define exception. Explain the types of exception? Explain about PL/SQL VARRAYS?

Part-C
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Define Constraints? Describe Constraints and its types? Describe how to alter an existing table? Discuss briefly on built in functions. How data can be restricted with WHERE clause? Explain join? Explain views? Describe how control structures are used in PL/SQL? Explain how variables and Anchored declaration used in PL/SQL? Describe cursor with example? Briefly discuss on: [Link]/SQL records [Link]/SQL tables.

You might also like