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 |
What is posting?
What is rank () in sql?
What does := mean in pl sql?
Is sqlite good enough for production?
Does inner join remove duplicates?
I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
when normalization is required
Can we use join in subquery?
Difference between inline query and stored procedure?
Difference between DBMS and RDBMS...CODD's rules
How to assign sql query results to pl sql variables?
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)