 Related Questions In oracle we are using dual table name for the temporary purpose. which table we are using in SQL server Latest Answer : hello dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc dualName Null? ... If we create a table having a column of BLOB data type then how we have to insert and retrieve the data? Read Answers (1) | Asked by : vishal Latest Answer : select from where mod(,2)0 ... Read Answers (3) | Asked by : Sudhir 1. Queris for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whoose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query? Read Answers (7) | Asked by : DEBPROSAD BANERJEE A view is created on a table then i dropped the base table and created the base table once again with the same name then that view will works or not? Read Answers (11) | Asked by : suresh What is the difference between Varray And Nested Table? Latest Answer : They are Oracle data types those who knoww any language like C and java then it is easy to understand the concept of Varray, as it is related to ARRAY structure of C or java language. where as Nested Table concept is related to Struct data type of ... A table which consist of atleast one primary or Unique key is called as Parent Table.
True / False (Justify) Latest Answer : Wrong and RightDepends how you take it. If i have emp table without primary key and i search dept table through emp id. Then this would be wrong. So, depends how you take it all i say is it's not verdict but it's an concept ... If you have an open cursor on a table, modify the same table and commit, what would happen? Latest Answer : The open cursor execute the query associated with the cursor, identifies the result set, and position . ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
