What is the difference between view and materialized view in Oracle?
No Answer is Posted For this Question
Be the First to Post Answer
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What are the restrictions in a oracle read only transaction?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
When a form is invoked with call_form, Does oracle forms issues a save point ?
How to get execution statistics reports on query statements?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
Explain view?
What are the execution control statements in oracle?
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 a cluster?
Explain the use of control file?
what is difference between sql plus and sql*plus? (not sql and sql plus).