https://www.sqlines.com/ 2026-04-14T06:33:56+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2012-02-25T17:52:37+00:00 https://www.sqlines.com/oracle/how-to/get_days_left_in_month?rev=1330192357&do=diff Given a date, how to find out the number of days left in the specified month? Oracle Query The following query shows how to get the number of days left in the current month (SYSDATE returns January 11, 2012 in this example): SELECT LAST_DAY(SYSDATE) - SYSDATE FROM dual; -- Result: 20 text/html 2012-04-27T11:33:15+00:00 https://www.sqlines.com/oracle/how-to/show_oracle_dump_content?rev=1335526395&do=diff SHOW=y option of the IMP utility allows you to see the content of an Oracle dump/export file (.dmp). When this option is specified, IMP outputs the SQL statements contained in the export file in the order in which Import will execute them. IMP utility outputs the content to the screen, and you can re-direct it to a file: