What does “select count(*) from tab” result?
Answer Posted / rahul koshti
This results the total count of tables,views,synonyms and
sequences present in a schema.
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
how do you control the max size of a heap table? : Sql dba
Can we use views in stored procedure?
How do you write an inner join query?
Determine if oracle date is on a weekend?
What are sql triggers used for?
What is auto increment?
How is sql used in oracle?
Write the alter statement to enable all the triggers on the t.students table.
How do you select unique values in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What kind of join is join?
what is an index? : Sql dba
What are the ways on commenting in a pl/sql code?
Explain lock escalation? : Transact sql
What is crud stand for?