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
- 11883 Views
- IBM, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / neo
Synonym can be created on non-existing table without using
Force keyword. It automatically become valid once table is
created.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is on delete restrict?
What is the difference between sum and count in sql?
what are the differences between char and varchar? : Sql dba
How many aggregate functions are available there in sql?
What is difference between nchar and nvarchar?
How do we accept inputs from user during runtime?
What is procedure function?
Explain what is a subquery ?
Explain the select statement in sql?
How do I view tables in mysql?
Explain the uses of database trigger.
Can sql developer connect to db2?
What is a sql driver?
What is trigger types of trigger?
