How to create a view on a table which does not exists
Answer Posted / vijayakumar
Using FORCE Command we can create a view without base table.
| Is This Answer Correct ? | 40 Yes | 1 No |
Post New Answer View All Answers
How do you declare a user-defined exception?
Why we use sql profiler?
Is inner join same as self join?
What is the difference between execution of triggers and stored procedures?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is not equal in sql?
What is anonymous block in sql?
How to use distinct and count in sql query? Explain
What sql database should I use?
what are the 'mysql' command line arguments? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
Show the two pl/sql cursor exceptions.
Can we use join in subquery?
What are triggers in sql?
What is normalization in sql?