Lab Sql

I have problem: I have 1 sql server already setup SQL Server 2014 Express in Windows and 1 Oracle D… Read more Unable To Enlist In The Transaction

This is in continuation of this thread I have the below query to have the value as heading using … Read more Dynamic Query For Pivot In Clause

Let's say a have a table with a varray column, defined as follow: create or replace TYPE VARRAY… Read more Accessing 2th Element In Varray Column

I want to pass variables in sqlplus command in my bash script, answer might be given but doesn'… Read more Passing Variable User,pass,sid In Sqlplus Comman

I have a data set like this -- **Team Date W/L** Team_1 04/01/0012 W Team_1 06/01/0012 W Te… Read more Grouping And Counting

I have a query which returns out result in following Form: Element READING1 READING2 READING3 --… Read more Transpose Query Result In Oracle 11g

I have these tables with the following columns : Employee24( EMPLOYEEID, FIRSTNAME, LASTNAME, GENDE… Read more Query To Find Employees Who Have Taken More Than Their Eligible Leave With Respect To Their Job Roles

I have the below types CREATE OR REPLACE TYPE 'CLONE_PRODUCT_CHAR_RECORD' IS OBJECT ( Ch… Read more Search Inside Table Type Of Records

I have replaced my original question with this final answer. With the help from Mr. MTO and Mr. Pon… Read more In Oracle 11g How Do You Time Weight Average Data Hourly Between Two Dates?

This is a follow up question to Transpose one row into many rows Oracle I want to be able to unpivo… Read more Have Unpivot Automatically Grab Column List (oracle 11g)

My C program has an embedded sql query. This program runs on windows and queries the oracle databas… Read more Check For Zero Rows In Select Query

We're creating a 'blank'/minimal copy of an existing database and want to reset one of … Read more Reset Sequence To A Specific Value

I have created a table with Blob datatype but I do not know how to insert values into the table or … Read more How To Insert Blob Datatype Values In Oracle 11g Database Through Sql*plus

I have a table as follow: |----------|----------| | DT | FLAG | |----------|----------| |… Read more Sql: Inserting Row For Missing Month(s)

I have a requirement in oracle SQL where the multiple rows are to be converted into single row. Her… Read more Multiple Rows Values Into A Single Row

I have a database where I get lots, defects and quantities (from 2 tables). After changing the name… Read more Oracle - Select Dense_rank Over (order By, Sum, Over And Partition By)

Can someone please tell how can I get the results as below. Using dense_rank function where rank S… Read more Using A Pl-sql Procedure Or Cursor To Select Top 3 Rank

I have 4 different tables: table_price_product (contains information related to the products and … Read more Creating Json And Editing A Complex Query (oracle 11g)

I have a scenerio where i have to update all the rows but one out of many rows.Say I have a table l… Read more How To Update All Rows Except One Row Out Of Many Satisfying The Given Condition?

I've read the Oracle docs on creating triggers and am doing things exactly how it shows, howeve… Read more Oracle - Problem Creating Trigger That Updates Another Table