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
write a qurey for finding the length of the sting. infosys   5  3611
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? virtusa   0  843
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  5412
What is a REF CURSOR? Compare strong and week ref cursor types.    6  7644
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry. polaris   5  3639
How One can easily select all even, odd, or Nth rows from a table using SQL queries?    3  7411
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ? hcl   2  2861
what eliminate duplicate without using roenum and not matrix   5  2505
how to create user in sql and how to set password for that?    3  4469
How can we overcome recursive triggers in SQL? iflex   1  4288
what is the difference between the query and corelated query ibm   8  4516
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  860
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  986
what is indexing, searching and user interface? hcl   0  298
What is RAC in oracle?    7  10534
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
 
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000 751
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 500
what is the difference difference between procedure and packages 1183
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
Could you please provide oca (oracle 10g) dumps for my certification ? 784
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ? 284
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 312
i have some prob lem to tell me about my self in interview first round ... 160
what is the bond code in materialized view? 613
what is single byte over head in oracle..? 386
write a query that returns first characters of each word in Oracel/Sql pl sql 2034
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 272
What are code pages ? 360
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution 474
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???? 986
E-Mail New Answers        Answer Selected Questions