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
   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 create a database in oracle?    2  1828
write a qurey for finding the length of the sting. infosys   5  3620
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? virtusa   0  844
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS polaris   6  5420
What is a REF CURSOR? Compare strong and week ref cursor types.    6  7659
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry. polaris   5  3647
How One can easily select all even, odd, or Nth rows from a table using SQL queries?    3  7424
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ? hcl   2  2869
what eliminate duplicate without using roenum and not matrix   5  2510
how to create user in sql and how to set password for that?    3  4474
How can we overcome recursive triggers in SQL? iflex   1  4292
what is the difference between the query and corelated query ibm   8  4525
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#    1  862
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????    0  987
what is indexing, searching and user interface? hcl   0  300
E-Mail New Answers        Answer Selected Questions        Post New sql-plsql Questions
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25    28   [29]    30  ... 33   ... 37   ... 41   ... 45   ... 49   ... 53    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
What are code pages ? 362
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.. 248
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 553
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 844
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... 309
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 501
what is the difference between trigger and constraint? 757
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.  5
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 361
what is the bond code in materialized view? 613
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 313
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me 244
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews 182
What is the criteria while applying index to any column on any table. 130
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 333
E-Mail New Answers        Answer Selected Questions