Lab Sql

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

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?

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

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

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

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

I have the following problem in my application which connects to an Oracle 10g database: When my cl… Read more Oracle: How To Detect Client Process Termination Like It Works For Sqlplus?

i have a table which contains user_rights on folders. Considering that rights are inherited on fold… Read more Oracle Hierarchical Query Start Clause From Join