How to fetch records from a partitioned table?
- 2 Answers
- 7195 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / nitinsharma06
select * from tabe_name partition (partition_name );
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is partition by in sql?
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...
Why triggers are used?
What is the source code of a program?
How to execute a stored procedure?
How do you write an inner join query?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Why select is used in sql?
What is difference between inner join and self join?
What is the maximum number of triggers, you can apply on a single table?
What is nvl?
What is sql integrity?
In pl/sql, what is bulk binding, and when/how would it help performance?
Can we use views in stored procedure?
what is primary key? : Sql dba
