Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- sql_dba_scripts [2010/04/26 21:24] – gpipperr
+++ dba:sql_dba_scripts [2010/04/30 15:18] – Seite verschoben von sql_dba_scripts nach dba:sql_dba_scripts gpipperr
@@ Zeile 8: / Zeile 8: @@
 <code plsql>
   -- Setup some SQLPlus parameters.
-  SET heading off
+SET heading off
   -- Spool everything to an file to reuse the generated SQL.
-  spool synonymspool
+spool synonymspool
   -- Do the Query.
-  SELECT 'CREATE SYNONYM ##DESTINATIONSCHEME##.' || TABLE_NAME || ' FOR ##SOURCESCHEME##.' || TABLE_NAME || ';' FROM cat WHERE TABLE_NAME NOT
+SELECT 'CREATE SYNONYM ##DESTINATIONSCHEME##.' || TABLE_NAME || ' FOR ##SOURCESCHEME##.' || TABLE_NAME || ';'
-  LIKE 'BIN%';
+  FROM cat WHERE TABLE_NAME NOT  LIKE 'BIN%';
   -- Close spool.
 spool off