Please find my answers below

----- Original Message -----
From: "Shantinath S Savalekar "
<oracledba-ezmlmshield-x64500994.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 30, 2005 7:49 AM
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?

Materialized views are those which contain defination as well as data also,
You can referesh content of materialized view from base table based on
different option either complete / fast/ etc...
For Application tunning, you can use this by enabling Query Rewrite feature
for your database

> 2.can synonym can hold data?
No

> 3.can views be updated?
Yes if view is simple view not having any group by function, distict clause
used in the sleect clause

> 4.scope of local variables in packages? / scope of global vairbles in
> packages?
Local variable will be visible and used with the package body
Global variable which will be visible to all other objects in that session
decalred in package specification

> 5.what is package? / package specification and package body
Package Spec: just contain the defination of all variable, function
procedure
Body: Contain implementation of defined function / procedure in package
specification

> 6.can commit be used in triggers?
Not directly, but using autonomous transaction you can user

> 7.row and statement trigger?
Row level trigger fire for every row which got effected
Statement level trigger which fire once for the statement irrespective of
how may rows has been effected

> 8.can we use implicit cursor?
Using Pesudocoloumns like SQL%rowcount etc.

> 9.what is left outer join? and what will be its result when used with and
> condition?
Left outer join means all record will be fetched from the left table where
join column data exist or not.

>
> 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
>
>


Oracle LazyDBA home page