Archive for 2013
Oracle : Download Oracle Enterprise Packs
January 10th, 2013, posted in Oracle
Oracle : How to Show Time with Date in a Session ?
January 8th, 2013, posted in OracleIf your want to show time with date in your sql environment like, working with Sql Developer or Sql Plus or iSql Plus then change the value of NLS_DATE_FORMAT.
To change the value log in the sql environment and write:
alter session set NLS_DATE_FORMAT =’DD-MON-RRRR HH:MI:SS AM’;
then check the value…you are done..!!!
*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
well.
*********************************************************************************************************************
Oracle : How To show/ get First Date of the Month ?
January 7th, 2013, posted in OracleIf you want to show or if you need the month first day, last time I check there was no built-in function in Oracle. But you can get it easily by using some other single-row date function. Here bellow an example of this.
SELECT LAST_DAY(ADD_MONTHS(SYSDATE,-1))+1
FROM DUAL;
Run the above sql and you will get the first day of current month.
For last day of current month just use the LAST_DAY function like this LAST_DAY(SYSDATE)
Need more help ? Just Leave you comments…
*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
well.
*********************************************************************************************************************