Answer Posted / durgaprasad sr
Actually why PL/SQl is existing when SQL is already there is...
To convert all the values present in a table to VARIABLES so that we can present the data on front end. untill and unless you convert them to variables you cant see the output on front end..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give the order of sql select?
What is spool?
what is error ora-03113: end-of-file on communication channel?
What is a dynamic query?
what is the difference between delete and truncate commands? : Sql dba
Define sql delete statement.
How many sql statements are used? Define them.
Is pl sql a scripting language?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Which constraints we can use while creating database in sql?
What are different types of sql commands?
How much does a sql dba make? : SQL DBA
How does a self join work?
What is a primary key called that is made up of more than one field?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?