Answer Posted / 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 |
Post New Answer View All Answers
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is view explain with example?
What is pragma in pl sql?
How many types of tables are there?
Is sqlite good enough for production?
What is the meaning of disabling a trigger?
what is the different between now() and current_date()? : Sql dba
What are the different types of joins in sql?
Why do we need databases?
How do you clear the screen in sql?
How to run pl sql program in mysql?
How long does it take to learn pl sql?
What is pl sql variable?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Can we have two clustered index on a table?