How to get system date from Oracle database using query
Using SQL query, how to fetch the system date from Oracle database?
and is it possible to get the date in specific format like "YYMMDD" or "DDMMYY"?
please explain in detail since I am very new to database queries.
I am writing a shell script to check database connectivity and I need this information to fetch the database date and to compare it with UNIX system date.