what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is foreign key sql?
What is implicit cursor in pl sql?
What are the various levels of constraints?
How do you optimize a stored procedure query?
. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so
How many types of privileges are available in sql?
What are different categories of sql commands?
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
Is a table valued function object?
Can we use the cursor's to create the collection in PL/SQL?
25.67,-1 Trunc = 20 Round= 30 HOW????
Can you join views in sql?