what are the forced views

Answer Posted / sunny

Without creating a table we can create a view by using forced view.

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which tcp/ip port does sql server run?

540


What is difference between sql and mysql?

537


Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

539


how can we optimize or increase the speed of a mysql select query? : Sql dba

515


Which is better varchar or nvarchar?

550






Show how functions and procedures are called in a pl/sql block.

588


define join and explain different type of joins? : Sql dba

548


What is sql and its types?

628


What is the maximum number of triggers, you can apply on a single table?

547


What is sql deadlock?

567


What are the datatypes available in pl/sql ?

616


What is the difference between a database and a relational database?

563


What is sql in java?

549


What is cross join example?

556


How can you create an empty table from an existing table?

597