Would like to have the general query command to run against an Oracle 11g database that will provide me the system date and time for the database. I've used it before, but can't find it.
"select * from v$instance" does work, but at one time I thought it did. I'm using SQL Developer to run my queries and usually I have no problems with simple queries. I've obviously not typing my command correctly.