Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
- 3 Answers
- 11599 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rajkumar
please don't give oracle answers in sqlserver
| Is This Answer Correct ? | 12 Yes | 8 No |
Post New Answer View All Answers
what is rdbms? : Sql dba
What does the acronym acid stand for in database management?
Why use truncate instead of delete?
What is auto increment in sql?
What is the difference between a query and a report?
Explain the select statement in sql?
Why should I use postgresql?
What is natural join in sql?
How to select unique records from a table?
What is a parameter query?
What is the process of copying data from table a to table b?
Why procedure is used in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
