title image


Smiley Re: Oracle: Sequence benennung
Hi,



also wenns zumindest ein anonymer PL/SQL Block sein darf, dann kannst du es so machen:



declare

l_seq varchar2(1000);

l_seq_name varchar2(30);

begin

select 'myseq'||myseq_count.nextval into l_seq_name from dual;

l_seq:='create sequence '||l_seq_name||' START WITH 1';

execute immediate l_seq;

end;

/





Damit kannst Du den Namen dynamisch zusammenbauen.



Dim



Zitat Tom Kyte:
I have a simple philosophy when it comes to the Oracle Database: you can treat it as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment.

OTN's "Greatest Hits" CD

SQL-Tips.de Das SQL-Wiki


geschrieben von

Login

E-Mail:
  

Passwort:
  

Beitrag anfügen

Symbol:
 
 
 
 
 
 
 
 
 
 
 
 
 

Überschrift: