Skip to content Skip to sidebar Skip to footer
Showing posts with the label Oracle

Oracle : Dynamic Column Name

Possible Duplicate: Oracle Rows to Column Transformation My real problem is just like this but ha… Read more Oracle : Dynamic Column Name

How To Return Multiple Rows From Oracle Stored Procedure From Multiple Cursors?

I need to have stored procedure where I can run multiple cursors. Loop over each cursor and then d… Read more How To Return Multiple Rows From Oracle Stored Procedure From Multiple Cursors?

Creating A Simple User Interface To Access An Oracle Database

Here is what I have: 1) a simple sql file given to me that creates tables and fills them with data … Read more Creating A Simple User Interface To Access An Oracle Database

Oracle - Get Current Date Formatted

I've been wondering - I have a lot of use with sysdate on my system, and when comparing it to m… Read more Oracle - Get Current Date Formatted

Ora-30926: Unable To Get A Stable Set Of Rows In The Source Tables

I am getting ORA-30926: unable to get a stable set of rows in the source tables in the following… Read more Ora-30926: Unable To Get A Stable Set Of Rows In The Source Tables

Query In Excel Without Heading - Oracle

Is it possible to export data into an excel sheet without the heading? I know SET HEAD OFF works in… Read more Query In Excel Without Heading - Oracle