Explore Oracle on Experts Exchange

In the following code I get the result as follows:

WITH SplitData AS (

    SELECT

        RULEID,

Hi Team, 

Iam workign on Oracle 12c  and working on the sample hr schema. 

Getting the below error

Can someone explain in detail and with a couple of examples what is the purpose of using CONNECT BY

I am creating a global temporary table for further processing.  It was working as expected.

I then

I created a temporary table that will generate between 3000-4000 records each time it is created

The name of databases is stored in a table in this format "XXXXXXXX:YYYXXXXX". I want to use substr

We've recently upgraded our DB from 18.xx to 19.21 and from APEX 19.xx to 23.2

Now, we're kinda

Hi Experts,

I have a 20-25 oracle tables and want to use it on ms sql.

What is your suggestion for

Hi

I am migrating a schema  from one DB to another target DB using exp/imp.

The dump will not include