Is anyone here wicked awesome with Oracle?

[jackangel]

thanks.

 

[Devastation]

no, i'm not

 

[jnevin]

Wicked awesome? Are you from Southie in Bombay?

 

[jackangel]

you're a wicked smoothie from dubai.

 

[Judo Tom]

depends on what your looking for?

what are you looking for?

 

[hamstershaver]

ive seen all of the matrix movies

 

[rudeboyja]

http://www.oracle.com/support/support_oracle.html

I know some but you can find most of what you need

 

[Cutiebaby]

jack angel where are you from?

 

[Lestat]

Oracle database or Apps? I am proficient in both.. you need some PL/SQL or what bro?

 

[jnevin]

Oracle database or Apps? I am proficient in both.. you need some PL/SQL or what bro?

Either I just read backwards greek, or I need to take a computer course.

 

[Lestat]

Either I just read backwards greek, or I need to take a computer course.

its cool man, even I don't get it sometimes.

Here is some of my current work, just a piece of the puzzle, but this is about as basic as it comes

delete
FROM corpdw.pc_trx
WHERE changed_by = 'FIN_UI_LD_PROJ_RES_PC_TRX'
and fiscal_year = 2005
and accounting_period = 12
and dept_id = '5000'
and account_id = '11110'
and project_id in ('60546','61373','61569','62429','62430','62582')
AND SCENARIO in ('ACTUALS', 'RESTATE')

 

[Judo Tom]

leestat: what do you do for a living? what languages do you use?

I am a developer and mainly use SQL for database stuff
I havent used PL/SQL since my sr project

 

[pintoca]

its cool man, even I don't get it sometimes.

Here is some of my current work, just a piece of the puzzle, but this is about as basic as it comes

delete
FROM corpdw.pc_trx
WHERE changed_by = 'FIN_UI_LD_PROJ_RES_PC_TRX'
and fiscal_year = 2005
and accounting_period = 12
and dept_id = '5000'
and account_id = '11110'
and project_id in ('60546','61373','61569','62429','62430','62582')
AND SCENARIO in ('ACTUALS', 'RESTATE')

emphasis on basic orb!!!

nicer would have been to have the project id retrieved with a nested select from a table where you keep projects updated according to a certain criteria, instead of hardcoding it like that...

then again, if this is a one-off deletion, it is ok

BTW, I don't deal with this anymore, used to do some DB2 and oracle back in 97-98... nowadays is simply MySql for my private website

 

[hamstershaver]

a lot of in this thread

 

[jackangel]

definitely looks like a one-off. i do DML like that daily against development or production.

 

[Raina]

I don't know anything about Oracle but I'm fantastic.

 

[bran987]

a lot of in this thread

This thread makes me feel very un

 

[hamstershaver]

This thread makes me feel very un

no you are still a

 

[Judo Tom]