1. Please one question at a time!!!!!!!!

2. Commit in a trigger - you can call autonomous transaction functions.

KAzi

Marty Bertram wrote:

>We have been told NOT to answer RTFM questions!!!
>
>-----Original Message-----
>From: Shantinath S Savalekar
>[mailto:oracledba-ezmlmshield-x64500994.[Email address protected]
>Sent: Wednesday, March 30, 2005 7:49 AM
>To: LazyDBA Discussion
>Subject: Re: a procedure to compare to fields in tables needed
>
>
>Hi Guruus........
>
>Coukld you provide me the below answer.
>
>1.what is materialized view?
>2.can synonym can hold data?
>3.can views be updated?
>4.scope of local variables in packages? / scope of global vairbles in
>packages?
>5.what is package? / package specification and package body
>6.can commit be used in triggers?
>7.row and statement trigger?
>8.can we use implicit cursor?
>9.what is left outer join? and what will be its result when used with and
>condition?
>
>Please .......your quick reply is appriciated
>
>
>Regards
>Shantinath
>
>
>----------------------------------------------------------------------------
>--
>The contents of this e-mail are confidential to the ordinary user of the
>e-mail address to which it was addressed and may also be privileged. If you
>are not the addressee of this e-mail you should not copy, forward, disclose
>or
>otherwise use it or any part of it in any form whatsoever. If you have
>received this e-mail in error please notify us by telephone or e-mail the
>sender by replying to this message, and then delete the e-mail and other
>copies of it from your computer system. Thank you.
>
>We believe this email to be virus free but do not warrant that this is the
>case and we will not accept liability for any losses arising from any virus
>being transmitted unintentionally by us.
>
>We reserve the right to monitor all E-mail communications through our
>network
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>


Oracle LazyDBA home page