you can remove the rows from the view if it does not containing any of the

a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.

Question Posted / pankaj

4 Answers
10596 Views
CGI, IBM, I also Faced
E-Mail Answers

Answer Posted / pankaj

you can remove the rows from the view if it does not containing any of the following.
1> group function
2> group by clause
3> distinct keyword
4> rownum keyword

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is text? : Sql dba

1121

what is column? : Sql dba

1053

what is a control file ? : Sql dba

1092

what are the different index configurations a table can have? : Sql dba

1043

What found sql?

995

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2205

Explain ddl statements in pl/sql?

1052

what are the advantages a stored procedure? : Sql dba

1021

What are sql indexes?

1048

Can we change the table name in sql?

1005

Are subqueries better than joins?

1042

How do you remove duplicate records from a table?

984

How is sql used in oracle?

1039

What normalization means?

1017

What are the advantages of indexing?

1031