PL/SQL - Create table??

[Nick366]

Is it possible to create a table within a PL/SQL block? Basically I am checking user_tables to see if a table exists, and if it doesn't then I am creating it.

declare
	v_count number;
begin
	select count(*) into v_count from user_tables
		where table_name = 'TEMP_2YEAR_DRIVER';

	if v_count = 0 then
		create table temp_2year_driver as (
			select A, B, C
			from subscriber);
	end if;
commit;
end;

 

[taupirho]

A couple of options.

If its forms PL/SQL
try using Forms_ddl built-in or the exec_sql package

If its regular PL/SQL just use execute immediate ' create tabe ...'

 

[sem]

In any case you don't need commit as any DDL statement ends your transaction. Then, even if that table already exists then an attempt to create it again just fails even faster then searching throug user_tables. So you may catch an error and process ( ignore ) it.


Regards, Dima

http://seminihin.narod.ru