GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

PL/SQL Interview Questions


PL/SQL Interview Questions

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

 
 PL/SQL Interview Questions
Sorting Options :  

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: Create Global temporary tables and say on commit preserve rows. The global temporary tables have data available till the session is active. So you if you insert it at one procedure and want to access it somewhere else you can do that very easily till ...
Read Answers (1) | 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 ...

What are the types of cursors apart from explicit and implicit cursors ? Explain when and where they are used ? 
Latest Answer: There are only two types of cursors in oracle Pl/sql.1. Implicit cursors2. Explicit cursors    We can define an explicit cursor as static or dynamic (REF CURSOR).    The difference between these two is   1. ...
Read Answers (2) | Asked by : Raja

SELECT APE.DAT_INSERT_DATE as "Payment Entry Date", Case when APE.TXT_INTERMEDIARY_CD is null or APE.TXT_PAYER_CUSTOMER_ID APE.TXT_INTERMEDIARY_CD then (Select TXT_CUSTOMER_NAME from GENMST_CUSTOMER 
Latest Answer: create or replace procedure sql_to_procedure as declare cursor c1 is SELECT APE.DAT_INSERT_DATE as "Payment Entry Date",APE.TXT_INTERMEDIARY_CD AS "Intermediary ID",APE.TXT_PAYER_CUSTOMER_ID as "CustomerID/Payer ID",TXT_CUSTOMER_NAME ...
Read Answers (1) | Asked by : preeti

Latest Answer: Yes using pragma autonomous_transaction as per example below for commit.we have two table employee and employee_bak of same structure (empid, emp_name, location, manager_id)--autonomous procedure will insert value in employee_bak, procedure is getting ...
Read Answers (2) | Asked by : piyush sachan

When a table is in state of transition it is said to be mutating. eg :: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select. 
Latest Answer: Mutate means chage. Mutating  table is a table that is being modified by update, delete or  insert statement. ...
Read Answers (3) | Asked by : Abirami

Char(20) = 'name' varchar2(20)='name' When comparing these two values, are the spaces padded in char are considered or not? Are both values equal?
Read Answers (5) | Asked by : ricky

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

Ask A Question
Go Top
 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
Sponsored Links

 
Free White Papers & Software


Vulnerability Management
for Dummies eBook

 


 

Request Your Copy
 



Free: 60-Day Trial
Microsoft Office Project

 


 

Request Now
 



The 7 Things that
IT Security Professionals
MUST KNOW!

 


 

Request Your Free eBook

 
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape