Hi ALL!

It looks like we a going to have a great commonly prepared PL/SQL
dedicated Meetup.
I have preliminary booked a day for that event (9th March 2010):
http://www.sydney...

Continue working on your ideas we are going to put things together after coming:
#19 How Build Fast, Secure Web Apps with the PL/SQL Gateway & Oracle Multimedia
http://www.sydney...


Yury Velikanov
Oracle [Apps] DBA

The Pythian Group (Sydney Office)
http://timeanddat...

From Sydney:
+61 (0)280147452 or +61 (0)280149235 x 277 - office
+61 (0)414252591 - cell

From US & Canada
+1 [masked]  x 277 - office

www.pythian.com
---------------------------------
IMs:
---------------------------------
Skype 	j.velikanovs 	
AIM 	pythianvelikanov 		
GTalk 	[address removed] 	
MSN 	[address removed] 	
Y! 	[address removed]
---------------------------------



On 3 February 2010 17:44, Sergey Porokh <[address removed]> wrote:
> 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]
>>
>>
>
>
>
>
>
>
>
> --
> 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 Sergey Porokh ([address removed]) from Sydney Oracle Meetup.
> To learn more about Sergey Porokh, 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]
>
>
--
Client of Pythian? On twitter? Let @paulvallee know and we'll add you
to @pythian/clients!