what command is used to create a table by copying the
structure of another table including constraints ?
Answer Posted / ben
crete view (view_name) as
select * from (table);
In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
i think this is the right answer
:)
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What does varchar include?
What are the subsets of sql?
what is data integrity? : Sql dba
How to select all records from the table?
Explain the methods used to protect source code of pl/sql.
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is sql mysql pl sql oracle?
How to call a javascript function from pl sql?
Explian rowid, rownum? What are the psoducolumns we have?
What are sql commands?
Mention what does the hierarchical profiler does?
What are sql queries used for?
How do you respond to dementia behavior?
what is the use of friend function? : Sql dba
Can we use join in subquery?