Skip to content Skip to sidebar Skip to footer
Showing posts with the label Oracle12c
Querying An Oracle Database With Dynamic Table Names

Querying An Oracle Database With Dynamic Table Names

Post a Comment
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
Alternate Of Sys_refcursor

Alternate Of Sys_refcursor

Post a Comment
What is the alternate of sys_refcursor. After 12c upgrade, the resultset of sys_refcursor is unreco… Read more Alternate Of Sys_refcursor
How Can We Get The 15 Minutes Time Interval

How Can We Get The 15 Minutes Time Interval

Post a Comment
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
How Can I Select 10th, 20th, 30th ... Row Of The Result Of Another Select Query

How Can I Select 10th, 20th, 30th ... Row Of The Result Of Another Select Query

Post a Comment
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
Oracle.dataaccess.client.oracleexception At Connection.open()

Oracle.dataaccess.client.oracleexception At Connection.open()

Post a Comment
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()
Wrong Symbol Inside Replace Function (pl/sql, Oracle)

Wrong Symbol Inside Replace Function (pl/sql, Oracle)

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