How to create a new table by selecting rows from another table?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the function of optimizer in oracle?
select statement does not retrieve any records. what exception is raised?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
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 differences between char and nchar in oracle?
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
What is object data modeling?
What is Read-Only Transaction ?
What is meant by raw datatype?
What is oracle database 10g express edition?
what diffrence between function and procedure?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group