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

 
 PL/SQL FAQ
Sorting Options :  

Latest Answer: Cursor is a private SQL area.. its a temporary buffer used to hold the transactional data on it n used to manipulate multiple rows through PL/SQL block statements. Temporary table can hold the records permanently and we can do DML operations on ...
Read Answers (1) | Asked by : spooja

Latest Answer: The PL/SQL Blocks are 2 types1. Ananymous Block2. Named Block1. Ananymous Block means with out any name.Ex:- DeclareBeginExceptionEnd.2. Names Block are Procedures/Functions/TriggersOk.....        CheersRav'i'ndra ...
Read Answers (2) | Asked by : brahmaiah

What happens if we don't write any thing between BEGIN and END in a procedure? If it show error than how can we execute this code error free?
Read Answers (1) | Asked by : vardan

Latest Answer: You must be speaking about PLS_INTEGER.  PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER which uses library arithmetic. As such PLS_INTEGER is somewhat faster than BINARY_INTEGER. Also BINARY_INTEGER has subtypes. I don't think PLS_INTEGER ...
Read Answers (1) | Asked by : srikanth kumar

Latest Answer: desc has two meanings and depends on the usage.when used in sql plus as in the below stt.desc ;it is taken as a sqlplus keyword and describes the table, dispalying column, constraints and data type for each column.an alternative is when ...
Read Answers (4) | Asked by : Amit kumar shukla

Latest Answer: In hash join hash table gets build using the inputs. Nested loops as the name implies uses looping construct strategy for storing and retrieving. In terms of performance comparison while retrieving data from both strictures hash join is best in terms ...
Read Answers (1) | Asked by : Ram Kumar

what is the differences between it. 
Latest Answer: Rule Based Optimization is an older technique which is used for optimization of queries but follows a fixed rule or strategy for achieving the same. But in contrast cost Based Optimization is a later new technique which is also used for optimization of ...
Read Answers (1) | Asked by : Ramkumar Singh

Latest Answer: Also as mentioned by our friend rowid is a unique hexadecimal format integer which takes up the representation as below      File: Block: Row One can retrieve rowid by using the statement as below:       ...

Latest Answer: select max([columnName]-4) from tableName ...
Read Answers (2) | Asked by : suresh

Latest Answer: you can use SYSDATE oracle.lv_today := sysdate;or select sysdate into lv_today from dual;both the statements assign sysdate to lv_today ...

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

 
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