ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
 Categories >> Software >> Databases >> SQL PLSQL       
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
package specification-3 procedures package body-2 procedures will is execute PWC  2  2618
four procedures is are there should i write their in a package  2  1458
can i call procedure in package TCS  3  3275
what is global variable in pl/sql  1  6413
how can i read write files from pl/sql  3  3101
how can i create a user defined datatype  3  2172
what is called after appearing where clause  3  1438
full outer join syntax  5  2161
difference between oracle 8i and oracle 9i  8  11422
difference between cursor and procedure in a package PCS  3  7453
a procedure one in two out parameters i am waiting it in a sql query can i get the output  1  1104
can i use dbms_output.put_line in a function u are telling as return statement  7  5002
after tell procedure whole code he asked can i write the same way in a function  3  587
can i give user defined exception in a package  2  2453
can i write pl/sql code in a package  2  2070
E-Mail New Answers        Answer Selected Questions        Post New SQL PLSQL Question
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33    36   [37]    38  ... 41   ... 45   ... 49    Next
 
 
    Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions
    MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions
    DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions
    SQL PLSQL Interview Questions     Databases AllOther Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
Could you please provide oca (oracle 10g) dumps for my certification ? 689  
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ? 259 ABC
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao... 326 Satyam
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5 525  
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters. 167  
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 469 IBM
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table... 292 Satyam
How well can multiple sessions access the same data simultaneously ? 303  
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews 164  
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc 354  
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com 306 TCS
write a query that returns first characters of each word in Oracel/Sql pl sql 1898  
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com