Re: executing trigger and pl/sql

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

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam