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 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 am setting a bind variable in a PL/SQL block, and I'm trying to use it in another query's… Read more Sqlplus - Using A Bind Variable In "in" Clause

Is it possible in a single SQL statement to do the following: Use a subset of telephone numbers in … Read more Sql Exclusion Query

I have a table (Meeting) with date type attribute (MeetDate) and another varchar2 type attribute (W… Read more Oracle To_char Subquery In Trigger

In this question, I was able to insert date in |----------|----------| | DT | FLAG | |---… Read more Oracle 10g: Inserting Missing Dates For Table With Others Values

Can anyone point me to the right syntax to use in order to create a table only if it does not curre… Read more Oracle Create Table If It Does Not Exist

I have a table like this in oracle: servername description … Read more String Splitting In Pl/sql

I am struggling with a query that tried few days back with a suggestion of one of SO user and got i… Read more Query Result Not Returned As Expected

Database is Oracle 10.2.0.1.0 - 64bit running on Red Hat Enterprise Linux ES release 4 (Nahant Upda… Read more Is This A Possible Oracle Bug Or Am I Missing Something?

I have the model table defined like: MODEL (id NUMBER, capacity NUMBER ) and the flight table def… Read more How Can I Do This Dynamical Update In Oracle?

I am hoping to find how I can get the kb size of a result set in OracleDB. I am not an sysadmin, bu… Read more Determine The Size Of A Sql Result Set In Kb

I have a table that keeps track of changes in customer profiles. Here's a simplified version: C… Read more Row With Latest Value By Customer And Month

I know it works by using SQL update activity set REFERENCE = EMPTY_CLOB() where id = ? But I cann… Read more How To Update Empty String To Oracle Clob

I tried to find solution for this problem for some time but without success so any help would be mu… Read more Comparing List Of Values Against Table

I have a scenario where we generate spool based on condition. The spool should generate only if use… Read more Condition Based Spool Generation In Oracle Sql Script

We have 2 databases - DB1 & DB2. Can I create a table in DB1 that has a relation with one of th… Read more Can I Create Foreign Keys Across Databases?

Say i have the following table, using Oracle 10g ARTIFACT_LABEL | DEPENDANT_ON test1 |… Read more Oracle - Recursive Query Using Start With... Connected By...?

I want to be able to insert a variable number of rows into a table based on user input? eg. Please … Read more How To Loop Accepting User Input With Pl/sql?

I have such a long query like this in Oracle 10g (needed for custom pagination). SELECT * FROM ( … Read more Pagination Custom Query Fetch First N Rows Error