Answer Posted / annam.n
dual is an imaginary table.it only used for process any
functions on there, but we can't view the structure of the
dual table.so the dual table is a magic table
| Is This Answer Correct ? | 6 Yes | 10 No |
Post New Answer View All Answers
What is informix sql?
How do I add a primary key to a table?
Can a table contain multiple primary key’s?
Does sql between include endpoints?
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 cursor and its types?
Why should I use postgresql?
How do I run a script in sql developer?
What is sqlexception in java?
What is scalar function in sql?
what is 'mysqlshow'? : Sql dba
how can you create an empty table from an existing table? : Sql dba
What is data type in sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Is natural join same as inner join?