Answer Posted / akki julakanti
pl/sql is a procedural language
it is extension to sql introduced by oracle,
to perform operations over a database.
Here we follow some sequence of steps or programs.
Advantages:
1.supports conditional,looping,modularity
2.Better performance
3.Portability
4.Allow subprograms
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is a trigger in sql?
What is pl sql package?
What is sql procedures and functions?
What is crud sql?
Are null values same as that of zero or a blank space?
What is the source code of a program?
How to test for null values?
what are the different tables present in mysql? : Sql dba
What is sql dialect?
What are variables in pl sql?
Can we use commit inside a trigger?
How do I save a sql query?
How do I find sql profiler?
what is a composite key ? : Sql dba