Archives: 11/28/2011

CREATE SHORTCUT DESKTOP NON-DEFAULT BROWSER

If like me you have Firefox set as your default browser in Windows XP but need to create a desktop shortcut to a web page but force it to open in Internet explorer or any other non-default browser there are two methods to achive this: 1) Right click on the desktop and select New ->…

DELETE WITH INNER JOIN

ORACLE (WHERE EXISTS) DELETE FROM suppliers WHERE EXISTS (select * from orders where suppliers.supplier_id = orders.supplier_id); ORACLE (WHERE EXISTS) DELETE FROM sigo_assortimento ass WHERE EXISTS (SELECT * FROM “of_refeass”@orto_2003.finiper.it r INNER JOIN “settori”@ORTO_2003.FINIPER.IT st ON r.CODSET = st.CODSET WHERE st.codset != 21 AND ass.cd_int = LPAD(st.CODREP, 2, ‘0’) || LPAD(r.CODSET, 2, ‘0’) || LPAD(r.CODINT, 6,…

Go Top