InterviewQues, faqs, SQL,sql+, PlSql,my sql, Sqlserver, Ms Sql, 7i,8i,9i,10i, SNIpEDstatus, Cloning Database, CPU Resources, Database Crashed, Deadlock, Editing commands, Elapsedtime, Formating Columns, Forms4.5FAQ, Hindi Format, Hit Ratios, Log block size, Multiple fields, Orcl loction on linux, Oracle_SID, Plan TIps,setup for calling, Snapshot too old error,Sols for DBA’s,Sql Via Command Prompt,values back to unix,Schema,Faqs, Interview questions and Real time stuff too,,
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
Posted by Real Time Scenario at 10:54 PM
Labels: Practice USER, SYSDATE Functions
3 comments:
Nice blog, Thanks For Sharing this infromative article.
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
Oracle Fusion HCM Online Training
Oracle Fusion Financials Online Training
Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
Oracle Fusion HCM Online Training
Oracle Fusion Financials Online Training
Post a Comment