if i perform any operation on views such as insert, delete
etc will my base table get affected?????
Answers were Sorted based on User's Feedback
Answer / ramesh
yes if it is simple view. error if it is compunt view
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / gourvendra singh
It will affect ur base table only when u having a simple
view and if you put null in the field which is primary key
of the base table then also the base table will not
affected. And if you are using the compute view then u r nt
able to insert or delete the records.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / slokh
yes if it is a simple view. may be if is a complex view -
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / radha sri seshu.kolla
yes it will effect if your view is a simple view (eg:
create or replace view empview as select * from emp;) this
is called simple view. if you use any joins or if u create
view using more than two tables then it is called complex
view. in case of comlex view the database will not effect.
Is This Answer Correct ? | 0 Yes | 2 No |
What is difference between sql function and stored procedure?
take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...
what happens if null values are involved in expressions? : Sql dba
How to read/write files from pl/sql?
How many postgresql users are there, worldwide?
what is bcp? When is it used?
How many types of privileges are available in sql?
Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?
How to fetch records from a partitioned table?
How do you use a while loop in pl sql?
how to create a database in oracle?
What is Materialized View? In What Scenario we Use Materialized View?