2015-04-06から1日間の記事一覧
PLSQLのお勉強用 #!/bin/ksh for i in SERVER do echo "sqlplus"; sqlplus -s appadm/appadm @a $i > ${i}.sql doneSET SERVEROUTPUT ON; SET FEEDBACK OFF; SET verify off; DECLARE cursor cursor_a is select * from all_tab_columns where table_name = …