How can we force the database to use the user specified rollback segment?
No Answer is Posted For this Question
Be the First to Post Answer
can we pass two out parameters at a time in function?please answer to my question
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 is an external table?
What happens to the current transaction if a ddl statement is executed?
How to initialize variables with default values?
What is a table index?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
How to connect to a remote server?
How do I find the database name in oracle?
What is meant by redo log buffer ?
How to create a temporary table in oracle?
How are extents allocated to a segment?