GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle SQL FAQ


Oracle SQL FAQ

Questions: 185
Comments: 637
 Oracle SQL FAQ Tags
 Showing Questions 1-10 of 186 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 Oracle SQL FAQ
Sorting Options :  

How to create table emp1 based on emp, except comm column?  
Latest Answer: CREATE TABLE emp1 AS (SELECT empno, ename, hiredate, sal                                    ...

How do we view the query used while creating a View table? i.e How to find the dependencies of a view table. 
Latest Answer: If you have toad, you can see everything. Just navigate to view throgh schema browser and check under the tabs "view". select your view and check all the properties from it. ...
Read Answers (2) | Asked by : parag08

How to display & in Oracle SQL output 
Latest Answer: Use concatenate operator ...SQL> select 'a'||'&'||'b' from dual;'A'---a&b ...

these are the columns in the exam_report tableEXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCEnow i want to know how many student have passed at the end of the yr for each paper? 
View Question | Asked by : radha11

How to rename a column in a SQL table? 
Latest Answer:  we can not change the name of the column in oracle once defined. if the column contains null only datatype,widtth we can changepls recognise this ...

How to lock a particular row of a table using SQL?  
Latest Answer: INSERT , UPDATE, DELETE operations implicity lock rows of a table that satisfies the condition.Explicitly you may lock a table using for update of as followsSELECT * FROM EMPWHERE EMPNO = 7369FOR UPDATE OF SAL NOWAITIt will lock single row of emp table ...

How to change rows to columns and columns into rows? 
Latest Answer: Use decode function. ...

Display deptno wise first three lowest salaries in ascending order of deptno and desc order of salary

display the 5th lowest sal from emp table using Correlated subquery 
Latest Answer: display the 5th lowest sal from emp table using Correlated subquerytable have data:----------------SQL> select last_name,salary from employee order by salary asc;LAST_NAME      SALARY---------- ----------Cat           ...

How to arrange date in week wise like from Monday to Sunday? 
Latest Answer:  SELECT TO_CHAR(hiredate,'DAY') FROM emp ORDER BY to_char(hiredate-1,'D'); ...

View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape