Advanced Search

Return to Snippet

Revision: 4847
at January 23, 2008 14:15 by thecrumb
Initial Code 
select 
    'create sequence ' 
    || table_name 
    || '_seq start with 1 nocache ;'  
from 
    user_tables
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Generate the SQL necessary to create sequences for every table. 
NOTE:  This doesn’t create sequences. The results need to be copied and run as a script.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Generate the SQL necessary to create sequences for every table (Oracle)

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL