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