Posts

Showing posts from 2014

How to disable Automatic Network Printer Discovery

Image
Click "Start" button and click "Control Panel" menu.
Click "Network and Internet". Click "Network and Sharing Center". Click "Change advanced sharing settings". Select "Turn off network discovery" Radio button and click "Save changes" button.
Reference: http://smallbusiness.chron.com/turn-off-auto-detected-printers-50195.html

Oracle: SQL to count record in all tables

If you want to know the record in all the tables from your database, can simply use this SQL command.

SELECT table_name,
               TO_NUMBER(extractvalue(xmltype(dbms_xmlgen.getxml('select count(*) c from ' || table_name)), '/ROWSET/ROW/C')) count
FROM user_tables
ORDER BY table_name;

Credit to https://community.oracle.com/thread/927598