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