Hello All,

I can contribute on 

-Multi tables Inserts, Returning Into clauses, Bulk commands 
-Analytical functions within SQL
-Real life sample of performance improvement- common mistakes and ways to fix them
-Real life samples of XML extraction from LOB/LONG data

Oracle e-Business suite development is based on following particular set of standards. Nothing exciting, but  might be interesting for those who work on OEBS projects. I can share this stuff.

Another interesting stuff to discuss:

Avoiding hardcode in Oracle e-business suite custom programs.

XML Publisher reports - pros and cons, samples. Can share this info if it's interesting.

Custom.pll/Forms personalizations

Can share experince on working with WorkFlow on Accounting generator sample

Kind regards,
Sergey Porokh

--- On Wed, 2/3/10, Casey Dyke <[address removed]> wrote:

> From: Casey Dyke <[address removed]>
> Subject: RE: [Sydney-Oracle] PL/SQL Meetup discussion
> To: [address removed]
> Date: Wednesday, February 3, 2010, 7:23 AM
> Yep - agreed.  Lets talk war
> stories, real life examples, best practice in enterprise
> envs ... Etc.
> 
> Bulk processing is of particular interest to our
> shop.  
> 
> 
> 
> 
> Casey Dyke
> Database Team Manager
> Service Delivery and Applications
> [address removed]
> Ph: (02) 8236 4004
> Fax: (02) 9223 8575 
> M: [masked]
> 
> -----Original Message-----
> From: [address removed]
> [mailto:[address removed]]
> On Behalf Of Andrey Goryunov
> Sent: Wednesday, 3 February 2010 3:05 PM
> To: [address removed]
> Subject: Re: [Sydney-Oracle] PL/SQL Meetup discussion
> 
> I personally would love to hear about use of PL/SQL arrays
> and different methods of their management, comparison etc in
> conjunction with sql statements (CAST, TABLE operations)
> 
> especially if somebody has examples of it in real life with
> big amount of data (data warehousing ETL)
> 
> Cheers,
> Andrey
> 
> On 3 February 2010 14:44, Gary Myers <[address removed]>
> wrote:
> > I'm happy to put my hand up for discussing /
> presenting some PL/SQL 
> > stuff and/or performance from a developer's
> perspective.
> > I've been chugging through Steven F.'s book and picked
> up some good stuff.
> >
> > Connor McDonald would be Australia's Mr PL/SQL
> (despite a website of 
> > www.oracledba.co.uk), but he's in Perth and there's a
> big gap between 
> > east and west coasts.
> >
> > I saw him present in Melbourne a few years back and it
> is....breath-taking.
> > You can get his slides from last year's talk at
> Melbourne. All 700 of 
> > them, presented over a single morning.
> Click-click-click. Its a unique 
> > style, but works well.
> >
> > There's a lot of PL/SQL that is simply control
> structures (loops, if/then..
> > etc) around SQL statements (possibly the more
> complicated stuff like 
> > multi-table inserts) or chopping around variables with
> functions that 
> > are pretty similar to SQL functions, mostly using SQL
> datatypes. 
> > Connor's book and Steven Feuerstein's both consider
> SQL as the foundation for PL/SQL.
> >
> > I'd guess the main complications particular to PL/SQL
> are 1. Exception 
> > handling and propagation 2. Record types and
> collections.
> > 3. Dynamic SQL
> > 4. Triggers (and why not to use them)
> > 5. Built-in packages like DBMS_JOB, UTL_FILE, UTL_HTTP
> etc.
> >
> > What sort of problems does EBS throw up in PL/SQL ? Is
> it performance 
> > related, session-state, something else And do they
> wrap their PL/SQL ?
> >
> >   Gary
> >
> >
> >
> >
> > --
> > Please Note: If you hit "REPLY", your message will be
> sent to everyone 
> > on this mailing list ([address removed])
> This message was 
> > sent by Gary Myers ([address removed])
> from Sydney Oracle 
> > Meetup.
> > To learn more about Gary Myers, visit his/her member
> profile To 
> > unsubscribe or to update your mailing list settings,
> click here
> >
> > Meetup Inc. PO Box 4668 #37895 New York, New York
> 10163-4668 | 
> > [address removed]
> 
> 
> 
> --
> Sincerely,
> Andrey Goryunov.
> 
> 
> 
> --
> Please Note: If you hit "REPLY", your message will be sent
> to everyone on this mailing list ([address removed])
> http://www.sydney...
> This message was sent by Andrey Goryunov ([address removed])
> from Sydney Oracle Meetup.
> To learn more about Andrey Goryunov, visit his/her member
> profile: http://www.sydney...
> To unsubscribe or to update your mailing list settings,
> click here: http://www.meetup...
> Meetup, PO Box 4668 #37895 New York, New York 10163-4668 |
> [address removed]
> 
> 
> 
> 
> --
> Please Note: If you hit "REPLY", your message will be sent
> to everyone on this mailing list ([address removed])
> http://www.sydney...
> This message was sent by Casey Dyke ([address removed])
> from Sydney Oracle Meetup.
> To learn more about Casey Dyke, visit his/her member
> profile: http://www.sydney...
> To unsubscribe or to update your mailing list settings,
> click here: http://www.meetup...
> Meetup, PO Box 4668 #37895 New York, New York 10163-4668 |
> [address removed]
> 
>