Advertisement
catalin_stefann11

Untitled

May 21st, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.31 KB | None | 0 0
  1. PROCEDURE construire_tabela( f_nume_tabela VARCHAR2) IS n NUMBER;
  2. BEGIN
  3. SELECT COUNT(*) INTO n FROM user_tables WHERE table_name = f_nume_tabela;
  4. IF n=0 THEN
  5. EXECUTE IMMEDIATE 'create table ' || f_nume_tabela || '(n number)';
  6. ELSE
  7. EXECUTE IMMEDIATE 'drop table' || f_nume_tabela;
  8. END IF;
  9. END construire_tabela;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement