Oops ORA-600... memory failure :)

-----Original Message-----
From: Chelur Jayadas
[mailto:oracledba-ezmlmshield-x80929254.[Email address protected]
Sent: 30 March 2007 12:10
To: LazyDBA Discussion
Subject: RE: EXPLANATION FOR THE QUERY

What's going on ? You had posted exactly the same message last
month (February 22, to be precise) and at least 4 persons, myself
included, had replied to it, explaining what exactly the SQL is
trying to do. This the message you had posted on 22 February :-

********************************************************************
From: KRISHNAMOORTHY Prabhu Ramachandran [Email address protected]
Sent: Thursday, February 22, 2007 8:22 AM
To: LazyDBA Discussion
Subject: what will be the result for this sql

Hi all,


I am new to oracle iam unable to judge what this below sql does

SELECT TO_DATE((RTRIM(TO_CHAR(SYSDATE ,'YYYY'))|| '-'
||RTRIM(TO_CHAR(SYSDATE ,'MM'))||'-01') ,'YYYY-MM-DD') FROM
ps_installation
********************************************************************


-----Original Message-----
From: KRISHNAMOORTHY Prabhu Ramachandran
[mailto:oracledba-ezmlmshield-x54917323.[Email address protected]
Sent: Friday, March 30, 2007 1:54 AM
To: LazyDBA Discussion
Subject: EXPLANATION FOR THE QUERY

HI ALL,


CaN ANY ONE GIVE ME A CLEAR EXPL FOR THE BELOW QUERY




SELECT TO_DATE((RTRIM(TO_CHAR(SYSDATE
,'YYYY'))|| '-' ||RTRIM(TO_CHAR(SYSDATE
,'MM'))||'-01')
,'YYYY-MM-DD')
FROM ps_installation


Thanks
Prabhu Ramachandran Krishnamoorthy

Confidentiality Statement:

This message is intended only for the individual or entity to which it
is addressed. It may contain privileged, confidential information which
is exempt from disclosure under applicable laws. If you are not the
intended recipient, please note that you are strictly prohibited from
disseminating or distributing this information (other than to the
intended recipient) or copying this information. If you have received
this communication in error, please notify us immediately by return
email.
-----------------------------


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page