Ali Şahan Blog Bir avuç SQL C# Oracle Lunix
Database ait tüm tablolarda hastane_no=1 olarak tanımlama,
select 'update '||table_name||' set hastane_no=1;commit;' from all_tab_columns where owner='HASTANE' andselect 'update '||table_name||' set hastane_no=1;commit;' from all_tab_columns where owner='HASTANE' and column_name='HASTANE_NO' group by table_name column_name='HASTANE_NO' group by table_name
