REM sqlplus script to compare 2 tables, shows different column values in color REM using my PL/SQL procedure compareTabs (http://aus-oracle.blogspot.com/2009/04/how-to-compare-2-tables-data.html) accept table_old prompt table_old: accept table_new prompt table_new: accept owner_old prompt owner_old: accept owner_new prompt owner_new: SET MARKUP HTML ON SPOOL ON HEAD - '<SCRIPT> - function deleteColumn(tblId, colNum) - { - var allRows = document.getElementById(tblId).rows; - for (var i=0; i<allRows.length; i++) { - if (allRows[i].cells.length > colNum) { - } - } - } - function start() { - var va = new Array(99); - var index_va = -1; - var table = document.getElementsByTagName("table")[0]; - table.setAttribute("id","tableid"); - var tr = table.getElementsByTagName("tr"); - for (j = 1; j < tr.length - 1; j = j + 1) { - var tr1 = table.getElementsByTagName("tr")[j]; - var tr2 = table.getElementsByTagName("tr")[j+1]; - - var tdAr1 = tr1.getElementsByTagName("td"); - var tdAr2 = tr2.getElementsByTagName("td"); - for (i = 0; i < tdAr1.length; i++) { - if (tdAr2[i].innerHTML != tdAr1[i].innerHTML) { - tdAr1[i].bgColor = "#00ffff"; - tdAr2[i].bgColor = "#00ffff"; - va[i] = 1; - } - } - } - for (j = 1; j < tr.length - 1; j = j + 2) { - var tr1 = table.getElementsByTagName("tr")[j]; - var tr2 = table.getElementsByTagName("tr")[j+1]; - - var tdAr1 = tr1.getElementsByTagName("td"); - var tdAr2 = tr2.getElementsByTagName("td"); - for (i = 0; i < tdAr1.length; i++) { - if (tdAr2[i].innerHTML != tdAr1[i].innerHTML) { - tdAr1[i].bgColor = "#90EE90 "; - tdAr2[i].bgColor = "#90EE90 "; - va[i] = 1; - } - } - } - for (i = 0; i < va.length; i++) { - index_va++; - if (i == 0) { - continue; - } - if (va[i] != 1) - { - index_va--; - } - } - } - </SCRIPT>' - BODY onload="start()" set linesize 32767 set termout off set timing off spool test.html exec compareTabs(:vc, '&table_old', '&table_new', p_owner1 => '&owner_old', p_owner2 => '&owner_new'); spool off host start test.html SET MARKUP HTML OFF set termout on
This site contains information, scripts and instructions related to Oracle database and other technologies. Please use sqlplus and test my scripts on test environment before actual use on production. All relevant comments are welcome.
Страницы
- Main
- Veritas cluster
- AIX
- Solaris
- Linux
- Performance scripts
- RAC
- TNS
- Init parameters
- Dataguard
- ASM
- Unix tips
- VxVM
- Linux HA (hearbeat)
- Oracle internals
- Metalink (useful notes)
- Security
- OGG Oracle Golden Gate
- HTML/JavaScript in sqlplus
- Automatic TSPITR 11.2.0.3 (dropped user)
- 12.1
- SQL Performance Analyzer
- Backup/Recovery
- Alert log
HTML/JavaScript in sqlplus
Подписаться на:
Сообщения (Atom)
Update BLOB
set define off DECLARE vb1 CLOB := 'long text'; vb2 CLOB := 'long text'; vb3 CLOB := ...
-
set define off DECLARE vb1 CLOB := 'long text'; vb2 CLOB := 'long text'; vb3 CLOB := ...
-
RMAN> sql "alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' off line"; using target database contro...
-
-- After media failure 03:03:25 150 4294967295 SYS@orcl> select * from t_t where object_name = 'test'; select * from t_t where ob...
Комментариев нет:
Отправить комментарий