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 
 


 

  Question  Asked @ Answers Views     select
 
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body Reliance  2  2446
what is variable in package specification  2  1986
i don't want the message as 14 rows updated just it should update what it will do  4  2664
how can i read files from a pl/sq l program  3  2562
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table? Wipro   26  15017
what is the command for user data type?  2  2239
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees. Wipro   12  6753
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT AOL  1  2411
In testing where do we use sql language and how it helps in testing?  2  2213
what command is used to create a table by copying the structure of another table including constraints ? eicc   5  5373
Find out the 3rd highest salary? BirlaSoft   50  22131
Difference between views and materialized views? BirlaSoft  4  8605
Write a simple program on cursors BirlaSoft  2  3239
How to convert ms-excel file to oracle table?  2  3361
what are the different types of joins? Choice-Solutions  4  4320
E-Mail New Answers        Answer Selected Questions        Post New SQL PLSQL Question
Prev    1   ... 5   ... 9   ... 13    16   [17]    18  ... 21   ... 25   ... 29   ... 33   ... 37   ... 41   ... 45   ... 49    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 531 IBM
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000???? 977  
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 326 TCS
what is single byte over head in oracle..? 382  
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 560  
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ? 279 ABC
We have a CURSOR then we need BULK COLLECT? 316  
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query 165  
How do you use collections in procedure to return the resultset? 314  
how will i became good database developer? 240  
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews 177  
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. 195  
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