tricky SQL questions please

[rakeshchinna]

13 minutes ago, mekapichal_mnthmkura said:

8 rows unnay.. aa data set lo..

4 pakkana migitha 4 ravali..

pivoting  type annattu.. cheyy

piovting kadu broo pivot eh case lo varthinchadu 

[mekapichal_mnthmkura]

13 minutes ago, mettastar said:

Substring and length batti case statement rayali

Code eyyu eeda.. balshinda?

[former]

14 minutes ago, mettastar said:

Logs chudali

Loga ante DBA kada. As a deveploer you can use ORA_ROWSCN pseudocloumn to get it in the query

[former]

15 minutes ago, mettastar said:

Substring and length batti case statement rayali

give the query ??

[mettastar]

15 minutes ago, ronitreddy said:

Ee tool vuncle?

datastage

[lelavathi]

16 minutes ago, ronitreddy said:

Ee tool vuncle?

Not informatica 

[sarkaar]

Read consistency and snapshot too old error ante ento cheppu. neeku entha skills unnayo cheptha

[mettastar]

3 minutes ago, former said:

Loga ante DBA kada. As a deveploer you can use ORA_ROWSCN pseudocloumn to get it in the query

transaction logs nunchi kuda identify cheyachu kada vuncle.. never heard of ORA_ROWSCN.. nive to know

[lelavathi]

3 minutes ago, mettastar said:

datastage

Ong?

[mettastar]

2 minutes ago, sarkaar said:

Read consistency and snapshot too old error ante ento cheppu. neeku entha skills unnayo cheptha

never heard of it vuncle.. SQL questions adugu vuncle .. 

[Srimantudu]

47 minutes ago, mettastar said:

thanks.. never heard of identity column..  sequence number antaga

u have to have the same data but only identity column values has to change

[mettastar]

7 minutes ago, former said:

give the query ??

select name

, case when length(regexp_substring(name,'[^  ]+', 1,1) )<>0 then regexp_substring(name,'[^  ]+', 1,1) end Fname

, case when length(regexp_substring(name,'[^  ]+', 1,2) )=1 then regexp_substring(name,'[^  ]+', 1,1) else null end MName

, case when length(regexp_substring(name,'[^  ]+', 1,2) )=1 then regexp_substring(name,'[^  ]+', 2,2) else regexp_substring(name,'[^  ]+', 1,2) end Lname

, case ... similar as above

from table

[mettastar]

7 minutes ago, Srimantudu said:

u have to have the same data but only identity column values has to change

ardam kaala .. is this another question u r asking me ?