Answer Posted / chaudhry
Schema objects are the logical structures that directly
refer to the database's data. Schema objects include tables,
views,
sequences, synonyms, indexes, clusters, database triggers,
procedures, functions packages and database links.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Use of an integrity constraint is better to validate data. Explain
 How to use an oracle sequence generator in a mapping?
How to get execution path reports on query statements?
What is meant by joins? List out the types of joins.
How to increment dates by 1 in oracle?
How to drop a tablespace?
Can we create trigger on materialized view in oracle?
What is the dynamic sql in oracle?
How to use "for" statements in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
How can we find out the duplicate values in an oracle table?
How to pass parameters to procedures?
is there a tool to trace queries, like profiler for sql server?
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