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 |
Does truncate need commit?
Is mariadb nosql?
How do we use distinct statement? What is its use?
how can stop the sequence with mention the max value and with out mention the max value
What is the clause we need to add in function body to return variable?
What is cursor in pl sql with examples?
suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 Answers Geometric Software, IBM,
What are all the different normalization?
When would you denormalize?
8 Answers MBT, Microsoft, MMU,
what is the difference between truncate and delete statement? : Transact sql
What is a loop in sql?
Does asenumerable execute the query?
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)