Explain the PL/SQL compilation process.
Answers were Sorted based on User's Feedback
Answer / nashiinformaticssolutions
The PL/SQL compilation process involves:
• Parsing: The PL/SQL code is checked for syntax errors.
• Compilation: The code is converted into a format the Oracle Database can execute.
• Storage: The compiled code is stored in the database.
• Execution: When the PL/SQL code is called, it is executed by the database engine.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / glibwaresoftsolutions
The PL/SQL compilation process involves:
• Parsing: The PL/SQL code is checked for syntax errors.
• Compilation: The code is converted into a format the Oracle Database can execute.
• Storage: The compiled code is stored in the database.
• Execution: When the PL/SQL code is called, it is executed by the database engine.
| Is This Answer Correct ? | 0 Yes | 0 No |
The PL/SQL compilation process involves:
• Parsing: The PL/SQL code is checked for syntax errors.
• Compilation: The code is converted into a format the Oracle Database can execute.
• Storage: The compiled code is stored in the database.
• Execution: When the PL/SQL code is called, it is executed by the database engine.
| Is This Answer Correct ? | 0 Yes | 0 No |
7. Where would you look for errors from the database design?
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
What are the pre requisites?
What is the advantage of nosql?
what is pragma ?
write a query to delete similar records in different tables with same structure
What is difference between stored function and application function?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is difference sql and mysql?
What is the difference between cluster and non-cluster index?
What does closing a cursor do?
Can cursors be part of a trigger body?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)