Get the database version in Oracle.

Simple and effective:

SELECT * FROM v$version WHERE BANNER LIKE 'Oracle%'

1228d1f3-a8cf-4753-92a8-4704ad49c0d0|0|.0

Categories: Databases

Posted by wizgod on Tuesday, August 24, 2010 12:48 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Get the date parts of a date in OracleOriginal Post: http://decipherinfosys.wordpress.com/2007/07/19/extracting-day-month-or-year-from-a-d...GETDATE() equivelant in OracleUse SYSDATE in Oracle: SELECT SYSDATE FROM dual; SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS')...Get display name of logged in user in InfoPathdisplay name, username, login, active directory, InfoPath

Comments

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Notify me when new comments are added

Byte My Data