Answers were Sorted based on User's Feedback
Answer / pavan_1981
PL/SQL is Oracle's Procedural Language extension to SQL.
PL/SQL's language syntax, structure and data types are
similar to that of ADA. The PL/SQL language includes object
oriented programming techniques such as encapsulation,
function overloading, information hiding (all but
inheritance). PL/SQL is commonly used to write data-centric
programs to manipulate data in an Oracle database
|Is This Answer Correct ?||16 Yes||2 No|
Answer / 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.
|Is This Answer Correct ?||7 Yes||2 No|
Answer / ehsraka
It has an edge over the normal sql commands, as it
increases performance by pushing the bunch of sql commands
into engine in a single go.
|Is This Answer Correct ?||8 Yes||4 No|
Answer / 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|
Difference between IN and EXISTS
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Differentiate between syntax and runtime errors.
function can return multiple value?how give give sample coding
i need department wise top 2 employees salary.which logic i will use
Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --
what is HASH join?
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body
What are the datatypes a available in PL/SQL ?