Re: executing trigger and pl/sql

Guido,

    Thank you. By pl/sql I meant blocks of sql stament.

Kiran
Guido Konsolke wrote:
> Hi,
> comments inline...
>
> "kiran" <kiran.news.invalid_at_web2news.net> schrieb im Newsbeitrag
> news:45993N590_at_web2news.com...
>> Hi,
>>
>> How could I execute a trigger in oracle, Similary how
>> could I execute a
>> pl/sql ?
>
> Trigger: by making the triggering event happen.
> PL/SQL: do you mean sth. stored in the database
> or anonymous blocks in SQL*PLUS? Stored procs
> etc. by entering 'execute procname;',
> anonymous blocks 'declare...begin...end ;/'.
>
>> Is there an optimized way to enter the current date and time into
>> a field, rather than picking sysdate from dual?
>>
> If you really need the current date/time, sysdate from dual
> is the way to go. If you want to use this value more than
> one time in your code, assign it to a variable and use this
> variable.
>
> hth,
> Guido

-- 
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.oracle.server