SQL> SET PAGESIZE 40000 SQL> SET FEEDBACK OFF SQL> SET MARKUP HTML ON SQL> SET NUM 24 SQL> SPOOL niger_duplicate.xls
SQL> SELECT INSTITUTE_ID,ROOM_NO, SIZE_NO,CLASS_NAME, NO_BENCH, NO_CHAIR, NO_TABLE, WRITNG_BOARD, NO_FAN, NO_LIGHT, PARTITION_TYPE, SL_NO, MULTIMEDIA, IS_ELECTRICITY FROM class_rooms GROUP BY SIZE_NO, CLASS_NAME, NO_BENCH, NO_CHAIR, NO_TABLE, WRITNG_BOARD, NO_FAN, NO_LIGHT, PARTITION_TYPE, INSTITUTE_ID, SL_NO, ROOM_NO, MULTIMEDIA, IS_ELECTRICITY HAVING count(*) > 1 order by SL_NO,institute_id;
SQL> SQL>SPOOL OFF SQL>SET MARKUP HTML OFF SQL>SPOOL OFF
you can find the spool output in your current directory.
default directory
No comments:
Post a Comment