Answer / monika

Yes, we can create a view on a table that really doesn't
exist yet.We can do this by putting a word (Force) in
create view command-

create force view v1 as
select * from emp;

here view gets created but its staus is invalid,its become
valid when we create table emp(table on which view is
defined).

Answer / anitha

It is true that the force option can be used to create the
view. But, this view will remain invalid even after the
creation the the Table. It needs to be recompiled again.

Answer / 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.

Answer / neo

Synonym can be created on non-existing table without using
Force keyword. It automatically become valid once table is
created.

What is sqlcontext?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

What are the different types of functions in sql?

0 Answers  

---

Is not equal in sql?

0 Answers  

---

Why is nosql good?

0 Answers  

---

What is a parameter query?

0 Answers  

---

How do I install microsoft sql?

0 Answers  

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---

What does inner join mean?

0 Answers  

---

What is offset and limit in sql?

0 Answers  

---

How to write html code in pl sql?

0 Answers  

---