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?
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
Why partition by is used in sql?
How can a pl sql block be executed?
What is pessimistic concurrency control? : Transact sql
Explain autonomous transaction.
Define commit?
What is normalisation in sql?
What is trigger explain it?
What is the process of copying data from table a to table b?
What is the usage of nvl function?
What is the difference between the sql*loader and import utilities? : aql loader
What is difference between hql and native sql?
What is the difference between partitioning and sharding?
What is the starting oracle error number? What is meant by forward declaration in functions?
i have some prob lem to tell me about my self in interview first round ...
How to set up sql*plus output format in oracle?