Introduction to dynamic sql in database

Introduction to Dynamic SQL in Database What Is The Rule of Oracle Parse SQL?

http://crbtech.in/Student-Reviews/Oracle-Reviews

Introduction to Dynamic SQL in Database 













Dynamic SQL is also known as Powerfull SQL. A simple system might immediate the customer for an worker wide range, then upgrade series in the EMP and DEPT platforms.

Use UPDATE declaration at precompile time.

A general-purpose review author must develop different SELECT statement for the various reviews it produces.

In this situation, the statement’s cosmetics is unidentified until run time.

Such statement can, and probably will, change from performance to performance are appropriately known as Dynamic SQL .

Dynamic SQL statement are not a part of your resource system, they are designed by the system at run time.

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

. 

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



l l

Sources to databases things such as content, indices, series, platforms, usernames, and views

Requirements for Powerful SQL Statements To signify an energetic SQL declaration, any of the following included SQL commands:             

ALLOCATE CLOSE DECLARE DESCRIBE EXECUTE FETCH FREE GET INCLUDE OPEN PREPARE SET WHENEVER

THANK YOU!!!