| Other Oracle General Interview Questions |
|| Asked @
|What is Row Chaining ?
|when loggined as SYSTEM,how to display all the users of database using sql query?
|write a query to count number of alphabets in given string
for example "APPLE"
write a query to generate sequence from 50 to 100
write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
|You have one employee table having 3 entries emp_id, Mgr_id
and salary. Mgr_id is also referencing emp_id. so now find
out the emp_id which are having the second highest salary,
under a particular manager.
|Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
|If server is in US and client is in india there is timezone
is diffrence, How can we display date in indian time when
data is displayed from US server timezone?
|How to restrict the duplicate records in table valuesets
|what is the difference between table and veiw?
|how to get the index id?
|Please help me how to write a Query to change the primary
key constraint from 1 attribute to another attribute in a
|how to see the data (in unix) using dataset in datastage?
|can a table has a column that has only view data and in
other columns we can change data?
|For more Oracle General Interview Questions Click Here |