PL/SQL Interview Questions

Questions: 236

Comments: 957

PL/SQL Tags

—

DBMS, Pointer

Showing Questions 41-50 of 236 Questions

<< Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>

Sponsored Links

PL/SQL Interview Questions

Sorting Options :

Is it possible to use commit or rollback in exception section.

Latest Answer: Yes you can use commit or rollback in exception block;select * from test123;A----------51 Declare s varchar2(2); Begin update test123 set a = a+10; select a into s from test123 where a=20; exception when others then rollback; dbms_output.put_line('test'|| ...

Read Answers (1) | Asked by : Chitendra ranjan

Answer Question Subscribe

How do you encrypt the function to prevent accessing from users without specific permission. ?

Latest Answer: Using wrap utility we can encrypt source code of a function to byte code (Not a readable format). Becareful there is no decrypt utility to convert source code back to ascii format. if you aim is just ...

Read Answers (4) | Asked by : suhasshah2007

Answer Question Subscribe

What are purity rules for functions? why they use ? what effects if not follow these rules?

Latest Answer: The purity level defines what structure the function reads or modifies.the types of purity level:1)wnds--write no database stage I.e the function does not modify any database ...

Read Answers (3) | Asked by : suhasshah2007

Answer Question Subscribe

Write sample code that can create a hierachical set of data without using a start with and connect by

Write sample code that can create a hierachical set of data without using a start with and connect by clause in PL/SQL

Read Answers (1) | Asked by : soorajsk_84

Answer Question Subscribe

What is the difference between right join and right outer join..

Latest Answer: Both are same. Right outer join returns all the reocrds that satisfy the join condtion + rest of the records from right (or second) table. ...

Read Answers (3) | Asked by : MuthuKrishnan

Answer Question Subscribe

Why DUAL table is not visible?

Latest Answer: DUAL is a part data dictionary and owned by SYS. You should not make modifications to this table. It contains only one row and one column of VARCHAR2 datatype.Used to refer an object which does not have any pysical reference in database ...

Read Answers (2) | Asked by : Manjeet

Answer Question Subscribe

What is the need for using function purity in pl/sql

Latest Answer: To be callable from SQL statements, a stored function must obey the following "purity" rules, which are meant to control side effects:1. When called from a SELECT statement or a parallelized INSERT, UPDATE, or DELETE statement, the function ...

Read Answers (1) | Asked by : kumar sai

Answer Question Subscribe

Which type of binding does PL/SQL use?

Latest Answer: late binding ...

Read Answers (6) | Asked by : narayani

Answer Question Subscribe

What is the difference between using IS and AS while creating a procedure, function package and package

What is the difference between using IS and AS while creating a procedure, function package and package body?

Read Answers (1) | Asked by : Rohith

Answer Question Subscribe

What is the disadvantage of out paramter in functions

Latest Answer: We cant use functions with OUT parameter in sql statements because there is no way for you to declare a variable in a SQL query and in order to call an IN OUT -- you need a local variable (to supply a value to be read from and to supply a place to put ...

Read Answers (3) | Asked by : Sushma

Answer Question Subscribe

View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>

Go Top

#	User Name	Count
1	krishnaindia2007	58
2	g_sidhu	57
3	rampratap409	26
4	ddkdhar	14
5	pankaj_gauba	11
6	hindol_saha	10
7	KD09714	10
8	satyam_Ora	9
9	geetha24	8
10	askvenki	7

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX