What is the difference between view and materialized view in Oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is null value in oracle?
What happens if the update subquery returns multiple rows?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are the differences between char and nchar in oracle?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What is literal?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
material view and view disadvantages?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is an oracle database?
Explain the use of constraints option in exp command.
What is a directory object?