How to define an anonymous procedure without variables?
No Answer is Posted For this Question
Be the First to Post Answer
What is a shared pool?
How to sort the query output in oracle?
How do you find current date and time in oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How to list all indexes in your schema?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Differentiate between function and procedure in oracle.
Can we store images in oracle database?
What is the implicit cursor in oracle?