Interested to Buy Any Domain ? << Click Here >> for more details...
What are the system predefined user roles?
- 0 Answers
- 1043 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to create a server parameter file?
How to rebuild an index in oracle?
How to update values in a table in oracle?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
How do I know if oracle is installed on windows?
Why we choose emp number as primarykey?
What is the data pump import utility?
What is pragma autonomous transaction in oracle?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What are the predefined tablespaces in a database?
Oracle General 
