What is the rule of oracle parse sql

Page 1

What Is The Rule of Oracle Parse SQL? In handling an SQL declaration, Parsing is a stage in it. When a program provides an SQL declaration, the program creates a parse call to Oracle Data source. During that period, Oracle Database: 1.

Assesses the declaration for syntactic and semantic credibility.

2. it.

Decides whether the procedure providing the declaration has rights to run

3.

Allocates a private SQL area for the statement.

It also determines whether or not there is a preexisting distributed SQL area containing the parsed reflection of the declaration in the collection storage or library cache. If so, the client procedure uses this parsed representation and operates the declaration instantly. If not, Oracle Data base produces the parsed reflection of the declaration, and the client procedure allocates a distributed SQL area for the declaration in the collection storage cache or library cache and keeps its parsed representation there. Note the main distinction between a program making a parse contact for an SQL declaration and Oracle Data base actually parsing the statement. Advantages of Powerful SQL Host applications that agree to and procedure dynamically described SQL statement are handier than simply included SQL applications. Powerful SQL statement can be designed interactively. For example, your system might simply immediate customers for a search situation to be used in the WHERE stipulation of a SELECT, UPDATE, or DELETE declaration. A more technical system might allow customers to choose from choices record SQL functions, table and view names, column names, and so on. Thus, dynamic SQL allows you to create extremely versatile applications. When to Use Powerful SQL In exercise, rule of SQL will come across nearly all your development needs. Use dynamic SQL only if you need its open-ended versatility. Its use is recommended when one of the following items is unidentified at precompile time: Written text of the SQL declaration (commands, conditions, and so on) The range of wide range variables The datatypes of wide range variables Sources to databases things such as content, indices, series, platforms, usernames, and views Requirements for Powerful SQL Statements To signify an energetic SQL declaration, a personality sequence must contain the writing of a real SQL declaration, but not contain the EXEC SQL stipulation, or the declaration terminator, or any of the following included SQL commands: ALLOCATE CLOSE DECLARE DESCRIBE EXECUTE


FETCH FREE GET INCLUDE OPEN PREPARE SET WHENEVER In most cases, the personality sequence can contain phony wide range factors. They hold locations in the SQL declaration for actual wide range factors. Because dummy host variables are just placeholders, you do not declare them and can name them anything you like. For Student Reviews visit here: http://crbtech.in/Student-Reviews/Oracle-Reviews


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.