Oracle SQL query to search records created on weekends in B2B 10g

Oracle SQL query to search records created on weekends


select * from B2B_INSTANCEMESSAGE where DOCUMENTTYPE='850 4010'

 where
TO_CHAR (messagedatetime, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH') IN ('SAT', 'SUN');

How to remount device in Linux

I had read only mount point /MOUNTDIRLIVE and wanted to change it for read and write so used following Linux command:


sudo mount -o rw,remount /MOUNTDIRLIVE