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
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Databases >> SQL PLSQL
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
How to convert ms-excel file to oracle table?    2  3412
Write a simple program on cursors birlasoft   2  3283
Difference between views and materialized views? birlasoft   4  8690
Find out the 3rd highest salary? birlasoft   50  22429
what command is used to create a table by copying the structure of another table including constraints ? eicc   5  5464
In testing where do we use sql language and how it helps in testing?    2  2248
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT aol   1  2443
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  6961
what is the command for user data type?    2  2276
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  15233
how can i read files from a pl/sq l program    3  2600
i don't want the message as 14 rows updated just it should update what it will do    4  2710
what is variable in package specification    2  2014
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body reliance   2  2489
package specification-3 procedures package body-2 procedures will is execute pwc   2  2779
E-Mail New Answers        Answer Selected Questions        Post New sql-plsql Questions
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33    36   [37]    38  ... 41   ... 45   ... 49   ... 53    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
Could you please provide oca (oracle 10g) dumps for my certification ? 806
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 565
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 316
How do you use collections in procedure to return the resultset? 321
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem.. 251
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 337
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974 1035
How well can multiple sessions access the same data simultaneously ? 328
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ? 291
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 584
What packages(if any) has oracle provided for use by developers? 902
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently 170
what is single byte over head in oracle..? 389
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... 353
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 274
E-Mail New Answers        Answer Selected Questions