Lab Sql

I'm stuck with some poor database design where I have to query tables that are named by date. T… Read more Querying An Oracle Database With Dynamic Table Names

What is the alternate of sys_refcursor. After 12c upgrade, the resultset of sys_refcursor is unreco… Read more Alternate Of Sys_refcursor

I am trying to fetch every 15min data in such a way that, if the current time is 23-10-19 11:11:30 … Read more How Can We Get The 15 Minutes Time Interval

I have a table with a column to, from and ID. I need to select only rows with every 10th ID which i… Read more How Can I Select 10th, 20th, 30th ... Row Of The Result Of Another Select Query

this question can look like a clone of others, but I can't find a correct answer to this one. T… Read more Oracle.dataaccess.client.oracleexception At Connection.open()

I have below procedure inside package: PROCEDURE test1 IS InsertST varchar2(32000) : = 'IN… Read more Wrong Symbol Inside Replace Function (pl/sql, Oracle)

So i have created a test table having a number column which is of the data type Number(11,8). Now w… Read more Number Format Issue In Oracle

SELECT * FROM v$version; Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Producti… Read more Oracle Xmltype Extract Based On Value And Condition

I have some sample code as follows: WITH xtbl AS (SELECT 1 AS xtbl_id, xm… Read more Modify Xml Node Value- Updatexml Equivalent For Oracle 12c

CREATE GLOBAL TEMPORARY TABLE tt_temptable( RowNums NUMBER(3,0), procNums NUMBER(18,0) )… Read more How To Insert Into Temp Table When Looping Through A String - Oracle - Pl/sql

I want to fetch million of rows from a table between two timestamps and then do processing over it.… Read more Oracle Pagination Strategy

How can I query for data having literal chars as colon, semi-colon and some part of text in Oracle… Read more Select Query With Literal Characters(colon, Semi-colon) In Oracle

I'm working on a homework problem for an intro SQL class that I'm taking. This week's t… Read more Sql (oracle 12c): How To Select Results From Another Select Statement (nesting?/sub--query?)

I am trying to get transaction counts for every hour. Normally it is a straight forward query by un… Read more Oracle Query, Get Count Of Records By Hour

First, I execute the following SQL statements. drop table names; drop table ages; create table nam… Read more Update With Join Syntax For Oracle Database

I'm following the JDBC Developer's Guide and trying to test the JDBC thin driver connection… Read more Oracle 12c Database Connection Using Thin Driver Throws Io Error

Assume, i have 4 columns in a table id | col1 | col2 | col3 now i want to transpose that into on… Read more Oracle How To Transpose Columns Into Rows Without Union

I'm tuning Oracle 12c DB and trying to load some tables to INMEMORY partition. So, I'm alte… Read more How To Collect Data From Inmemory Partition?

We have a generic table that holds multiple records (DDL and DML below): CREATE TABLE 'XXAB_ZZ_… Read more Correlated Subquery Working Differently For Oracle 12c And 11g

I have a database table like this emp_id start-date end_date title location 111 1-JAN-200… Read more How To Create Group By On Min And Max Date