What is this Site!!

All about Real time requirements in Orale Stay Tune!!
Showing posts with label Practice USER. Show all posts
Showing posts with label Practice USER. Show all posts

Tuesday, January 22, 2008

What are USER, SYSDATE Functions?

The USER, SYSDATE Functions:


USER function displays login name of the user.

SQL> SELECT USER FROM DUAL;

USER
------------------------------
SCOTT


SYSDATE function displays system date.(Date in your windows)

SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
---------
1-JAN-05