That was very helpful, many thanks
About timestamp, I understood that as long as the DB server is the one
to log times it is safe to use it without timezones?? (I am not using
any of the different timezoned clients??) am i missing the point?
about all_table_columns, it is just a simple view to ha
On Wed, May 18, 2005 at 09:07:55AM +0200, Samer Abukhait wrote:
>
> i am trying to execute an 'alter table' statement dynamically.. it
> seems that "execute" only works with DML..
A simple example shows that EXECUTE does indeed work with DDL:
CREATE TABLE foo (col1 integer);
CREATE FUNCTION exec
i am trying to execute an 'alter table' statement dynamically.. it
seems that "execute" only works with DML..
is there any way to execute DDL statements??
here is what i am trying to do:
create or replace function em.process_table (
p_table varchar)
returns
