what is the difference between table and veiw?
Answer Posted / sanjay kumar
View is a virtual presentation of data of a one or more tables and view is strongly recommended about the security purpose but table has own space in database and present data as physically existence .
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an index associated with a constraint?
How to save query output to a local file?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are operators in oracle?
Explain the use of indexes option in exp command.
What is data block in Oracle?
Explain the use of consistent option in exp command.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is using clause and give example?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to rename a column in an existing table?
What is the difference between primary key and unique key and foreign key in oracle?
What is a database table in oracle?
What is an oracle cursor variable?