Archive for July, 2013


PeopleSoft Tip : Making Clobs visible in Toad

Several times we want to Display CLOB data in Toad with no success. Here is an interesting SQL example which can be used to display the data.

Example: SELECT CAST(SUBSTR(DESCRLONG,1,40) AS VARCHAR2(40)) AS DESCRLONG FROM PS_MAINTENANCE_LOG ORDER BY DTTM_IMPORTED DESC

Advertisements

Detachment

Nugget: Be able to detach from becoming centered on , reacting to, focussing on, or overly responsible for others. Let people be responsible for themselves.

 

How: Practice hard to live your own life in a balanced way so that you will move up on your own personal agent. Weed your own garden, and stay in your bubble.

Nugget: If you want things to change, give a clear and direct signal of what you need to have happen.Don’t be part of the 81 % who lie about their feelings. Be the broken record.

How: Think about what you need to say and deliver it in a clear assertive way. Don’t be passive or aggressive.If you need to, start with small things. You do know what kind of bread you like, don’t you? Once you’re on a roll, you’ll get better at putting the signal out.

Nugget: Don’t take the bait.
How: Recognize the trap, choose not to fall into it and swim on to better things.
example:
Why are you telling me this
No i really don’t want to know this information
you’re probably right

Nugget: Exercise your “no” reflex to establish healthy boundaries to your comfort level. Your body will give you a signal that when you are saying “yes” you really mean “no!”

How: Be honest. Set limits. Be persistent. Step back and let others help.

Love Bank Account

Nugget: Open a Love Bank Account. Use it as an accounting system to transition to the five-to-one ratio.

How: Make the kind of deposits your partner needs most.

There are several times that in a project we need comma delimited column names of a record, below is an example on how to get it quickly!!!

Example on PS_JOB:
SELECT RECNAME,
MAX (LTRIM (SYS_CONNECT_BY_PATH (FIELDNAME, ‘,’), ‘,’)) keystring
FROM (SELECT RECNAME,
FIELDNAME,
ROW_NUMBER () OVER (PARTITION BY RECNAME ORDER BY FIELDNAME)
rownumber
FROM PSRECFIELDALL
WHERE RECNAME = ‘JOB’)
START WITH rownumber = 1
CONNECT BY PRIOR rownumber = rownumber – 1 AND PRIOR RECNAME = RECNAME
GROUP BY RECNAME