How do I call oracle stored procedures that take no parameters?

564

what are archived logs?

1717

How to execute the package in oracle?

570

Does oracle partitioning improve performance?

552

How to apply filtering criteria at group level in oracle?

587

How to define default values for formal parameters?

596

What is the data type of dual table?

527

Is java required for oracle client?

548

What happens in oracle commit?

568

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1470

Difference between inner join vs where ?

609

What is the difference between alert log file and tarce file ?

1634

What are the differences between interval year to month and interval day to second?

553

Why we use bulk collect in oracle?

536

Is truncate autocommit in oracle?

640