GeekInterview.com
  I am new, Sign me up!
 

PL/SQL Interview Questions


PL/SQL Interview Questions

Questions: 241
Comments: 1044
 PL/SQL Tags
 Showing Questions 31-40 of 241 Questions
<< Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 PL/SQL Interview Questions
Sorting Options :  

What is Global temporary table? and what are the benefits of it? 
Latest Answer: The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for the whole session, or just for the current transaction. ...

begin For i in 1..5 loop insert into A values(i); savepoint 1; end loop; rollback to savepoint 1; commitend;--initially there are no data in table A. So my question is after execution of this 
Latest Answer: The first mistake in this code is savepoint 1;You can't give 1 as identifier. Identifier name must begin with a letter.insert into A values(i);savepoint x;Here you are defining savepoint after inserting the value. So the final savepoint ...

Give an example for calling procedure with user and system exception 
Latest Answer: Simple example for predefined exception CREATE OR REPLACE PROCEDURE TEST_PROC AS A NUMBER ; BEGIN A := 'TEST'; DBMS_OUTPUT.PUT_LINE('THE VALUE OF A = '||A); EXCEPTION WHEN VALUE_ERROR THEN DBMS_OUTPUT.PUT_LINE('The value of A should ...

How will implement the PL/SQL tables? 
Latest Answer: - Pl/sql is in memory representation of a table.- It is just a data type. ( Collection type)- It may store any number of rows from table.Here is  a simple exampleCREATE OR REPLACE PROCEDURE TEST_PROC ASTYPE EMP_TYPE IS TABLE OF EMP%ROWTYPE;EMP_VAR ...

can we issue rollback, commit in the trigger body. if we issue what is the result 
Latest Answer: We can use commit and rollback in trigers using autonomous transactions.- An atonomous transaction is an independent transaction initiated by another transaction.- When an atonomous transaction is called the parent transaction is temporarly suspended.- ...

What exactly the difference between 'TABLE OF' and 'REF CURSOR' in PL/SQL?For what purposes these both might be used? 
Latest Answer: A ref cursor is a dynamic cursor in which the contents of cursor can be changed dynamically at run time depending upon our requirement.A ref cursor is basically a data type. A variable declared based on such data type is called cursor variable. We can ...
Read Answers (1) | Asked by : dgandhi

how to pass result set using refcursor from one package procedure to another package procedure? and code also 
Latest Answer: CREATE TABLE employees (empid   NUMBER(5),empname VARCHAR2(30));INSERT INTO employees (empid, empname) VALUES (1, 'Dan Morgan');INSERT INTO employees (empid, empname) VALUES (2, 'Jack Cline');INSERT INTO employees (empid, empname) ...

Which two statements are true?A. A function must return a value.B. A procedure must return a value.C. A function executes a PL/SQL statement.D. A function is invoked as part of an expression.E. A procedure must have a return Data
Read Answers (5) | Asked by : Ramanjaneyulu

Assume that I am using a temporary table in a procedure and I am inserting records and updating another set of records through Merge statement. If I use cursor in that temporary table, How can I extract 
Latest Answer: Make sure you do not COMMIT* in the middle of the procedure. You can do any number of insertion into and deletion from temporary table and use "Select * from temp_table" to fetch available data. Do not preserve rows unless it is required ...
Read Answers (2) | Asked by : Ramesh Venkatesan

Latest Answer: A Table is a basic unit of storage in oracle.A nested table is a collection type. The main advantage of collections is instead of processing data sequentially, we may process all the date  in one step.- It is a collection of rows stored ...

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

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape