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 FAQ


PL/SQL FAQ

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

 
 PL/SQL FAQ
Sorting Options :  

How to debug a procedure in SQL Prompt 
Latest Answer: You can debug the procedure. Oracle gives a util programme DBMS_DEBUG by which you can debug a procedure.the full detail you can see at http://www.oracleutilities.com/wiki/index.php?title=Dbms_debugand also you can find out the good material athttp://www.unix.org.ua/orelly/oracle/prog2/ch26_01.htmplsss ...
Read Answers (3) | Asked by : av_t66

Latest Answer: autonomous transaction  are independent transaction exCREATE OR REPLACE PROCEDURE a1ASPRAGMA AUTONOMOUS_TRANSACTION; BEGININSERT INTO table1 VALUES('autonomous transaction');COMMIT; END;DECLAREa NUMBER:=1;BEGININSERT INTO table1('a');proc_a;ROLLBACKEND;after ...

While i compiled my code , it got compiled but while running my application i got the Oracle error "Could not find the Program unit ? "Can any one tell exactly why this happens.I had validated 
Latest Answer: This error can occur in the following scenario also. The application has a constant connection with the database and a package which the application uses gets recompiled. And the recompiled package contains package variables. Solution :- Restart the application ...
Read Answers (2) | Asked by : Mukti

Latest Answer: Yes thats true...It will be private. ...

Latest Answer: Pragma is a compiler directive. It passes information to compiler. These are processed at compile time not at runtime.                  Types of PRAGMA1.AUTONOMOUS_TRANSACTION2.EXCEPTION_INIT3.RESTRICT_REFERENCES ...

Latest Answer: ORA - 01426 is associated with Numeric  overflow Cause : Evalution of an value expression causes an overflow or underflow.Action : Reduce the operand ...

Latest Answer: This will delete Collection (eg index by table ) in the range 6,3 ...
Read Answers (1) | Asked by : vijay

Latest Answer: A collection can be loosely defined as a group of ordered elements, all of the same type that allows programmatic access to its elements through an index. Commonly used collection types used in the programming world include arrays, maps, and lists. Probably ...
Read Answers (2) | Asked by : rk2007

we have a PRIMARYKEY field with auto generation in sequence of a table of records. If we delete any one of records from the table, how can we update the table implicitly using Trigger? 
Latest Answer: which table u want to update ,in case if it is the same table then write after delete  trigger on the table and select values from destination table. ...
Read Answers (1) | Asked by : Pranab Jyoti Deka

Latest Answer: Collection is an ordered group of elements all are of same time. Each element in the collection has unique subscript to identify its position in the collection.Pl/sql offers three collection types.1. Nested table2. Varray3. Index by table Use collection ...
Read Answers (2) | Asked by : Amit Navapara

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 (?)

 
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

 
Sponsored Links

 




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