Advanced Search

Return to Snippet

Revision: 36177
at November 19, 2010 02:37 by kamilch
Initial Code 
select 'CREATE or REPLACE SYNONYM ' || :target_schema || '.' || object_name || ' for ' || :src_schema || '.' || object_name || ';' from (
select table_name as object_name from all_all_tables where owner = :src_schema
union
select sequence_name as object_name from all_sequences where sequence_owner = :src_schema
);
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Generate SYNONYMS SQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PL/SQL