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 61-70 of 236 Questions
<< Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
 Sponsored Links

 
 PL/SQL Interview Questions
Sorting Options :  

View Question | Asked by : A.Jyothsna

Latest Answer: To add  primary key or unique key constraint Alter table tablename add constraint constraintname  primary key / unique (column name)To add check constraint Alter table tablename add constraint constraintname  check (codition)To add ...

Latest Answer: Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, ...

Why we use instead of trigger. what is the basic structure of the instead of trigger. Explain specific business reason of it's use

Latest Answer: select a.no  from (tablename) t1 a where rowid notin (select (max(rowid) from t1 b where a.no=b.no) ...

What is Pragma Init Exception ? what is difference between user defined exception and init pragma exception. what is the use of it.  
Latest Answer: You trap a nonpredefined Oracle server error by declaring it first, or by using the OTHERS handler. The declared exception is raised implicitly. In PL/SQL, the PRAGMA EXCEPTION_INIT tells the compiler to associate an exception name with an Oracle error ...

Suppose if i have 8 triggers declared for a table..how to disable a single trigger from a table...i don't want to disable all triggers for a table. I know we can disable all triggers by using "alter 
Latest Answer: Thanks parweej, alter trigger disable worked for me.. ...
Read Answers (3) | Asked by : Pavan

Latest Answer: Disadvantages of Triggers    It is easy to view table relationships , constraints, indexes, stored procedure in database but triggers are difficult to view.    Triggers execute invisible to client-application. They are not ...
Read Answers (2) | Asked by : Pavan

if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible 
Latest Answer: you can select the table for updationfor eg: select * from emp for update;no you can do the update/insert anything you want... any other user or session would be able to do any insert/update to the same table only after you release the table by commit ...

What is Force View. Why Oracle Give Facility to create force view? What is the use of force View 
Latest Answer: view is created with out base table that situation we use FORCE ...

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