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
What is the use of sqldataadapter?
how to concatenate two character strings? : Sql dba
Cite the differences between execution of triggers and stored procedures?
How does index help in query performance?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What are the most important characteristics of pl/sql?
How many unique keys can a table have?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How do you use join?
Can we insert delete data in view?
What is pl sql collection?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are the benefits of pl sql?
What is a table?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba