What are Schema Objects ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nishi
Schema objects are logical data storage structures. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle stores a schema object logically within a tablespace of the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
Explain what are clusters?
How to resolve the ORA-39133 error in Oracle?
Why do we need oracle client?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
create one table to capture an employee details with a primary key.
How to load excel data sheet to oracle database
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
if i am using dml statement in function. then i am writing select statement what was the output
Explain user account with reference to oracle.
How to start a new transaction in oracle?
Explain oracle’s system global area (sga).