Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose I have to create a view on a table, that is not yet been
created by DBA. I khow the table structure. Is it possible to
create the view before DBA creates this table? If yes then how?
Is it possible to create synonym in this way?
- 4 Answers
- 12954 Views
- IBM, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / ram
i cannot create a view unless the DBA gives me create view system privilege and to create a view in any schema, rather than just your own we need the create view privilege and be granted the select,insert,update and delete objects on table underlying the view.
synonym is the alias to database object and to hide details of source of the database object. a public synonym is created by the DBA and is available for use by any database user. a private synonym is defined in the schema by the user and is available to the user.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is a unique constraint?
How to call shell script from pl sql procedure?
what is datawarehouse? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is data type in database?
How does postgresql compare to "nosql"?
What is partition in sql query?
Does inner join return duplicate rows?
How do you remove duplicate records from a table?
How does an execution block start and end in pl sql?
Can we commit inside a trigger?
What are the types of join and explain each?
How to look at the current sql*plus system settings?
How does join work in sql?
What is nosql example?
