Re: executing trigger and pl/sql

Thanks for all the info

Kiran

Noons wrote:
> "kiran" <kiran.news.invalid_at_web2news.net> wrote in message
> news:45993N590_at_web2news.com...
>
>> How could I execute a trigger in oracle,
>
> Define it, then run the type of statement
> that causes the trigger to fire?
>
>> Similary how could I execute a
>> pl/sql ?
>
> From the SQL*Plus command line? EXECUTE.
> From JDBC? Call Executable_Statement().
> From ODBC? Call EXECUTABLE_STATEMENT().
> From OCI? Buggered if I remember... :)
>
>> Is there an optimized way to enter the current date and time into
>> a field, rather than picking sysdate from dual?
>
> field := to_char(SYSDATE,"mask"); -- should do it in PL/SQL.
>
> SELECT to_char(SYSDATE,"mask"),...
> INTO FIELD1,...
> FROM TABETC
> ...
> should do it from SQL. No need for DUAL anywhere.

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