Select from A table through cursor and update B table. If it updates successfully then insert into another table. Handled every type of exception in the code?

Read Answers (2) | Asked by : ddkdhar

Answer Question Subscribe

Explain, Is it possible to have same name for package and the procedure in that package.

Latest Answer: Yes, its possible to have same name for package and the procedure in that package. ...

Read Answers (1) | Asked by : sri

Answer Question Subscribe

What is dense_rank function and it's usage ?

Latest Answer: Rank Function can cause non-consecutive rankings if the tested values are the same. Whereas, the dense_rank function will always result in consecutive rankings. ...

Read Answers (2) | Asked by : ddkdhar

Answer Question Subscribe

What is diff between strong and weak ref cursors

Latest Answer: A strong REF CURSOR type definition specifies a return type, but a weak definition does not.DECLARE TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; -- strong ...

Read Answers (3) | Asked by : ddkdhar

Answer Question Subscribe

How to insert a music file into the database

Latest Answer: LOB datatypes can be used to store blocks of unstructured data like graphic images, video, audio, etc ...

Read Answers (1) | Asked by : rakheeviyyapu

Answer Question Subscribe

HiWhile creating a table, what is the difference between VARCHAR2(80) and VARCHAR2(80 BYTE)?

Latest Answer: Historically database columns which hold alphanumeric data have been defined using the number of bytes they store. This approach was fine as the number of bytes equated to the number of characters when using single-byte character sets. With the increasing ...

Read Answers (1) | Asked by : kkanmani

Answer Question Subscribe

What are the Limitations of Packages,views,procedures?What is the maximum number of subprograms inside

What are the Limitations of Packages,views,procedures?What is the maximum number of subprograms inside a package?

Read Answers (1) | Asked by : joseph

Answer Question Subscribe

What is the order of execution if there is a statement level and row level trigger on a same table?

Latest Answer: The correct order is as below. Trigger firing sequence: 1) Before statement level triggers, if present 2) For each row a) Before row level triggers, if present b) After row level triggers, if present 3) Actual Statement 4) After statement level ...

Read Answers (5) | Asked by : joseph

Answer Question Subscribe

Can we have same trigger with different names for a table?eg: create trigger trig1after insert on tab1;andeg:

Can we have same trigger with different names for a table?eg: create trigger trig1after insert on tab1;andeg: create trigger trig2after insert on tab1;If yes,which trigger executes first.

Read Answers (5) | Asked by : joseph

Answer Question Subscribe

View page << Previous 5 6 7 8 [9] 10 11 12 13 14 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