Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    37

    Unanswered: functio concat help

    Hi Guys I am stuck on a query


    basiaclly I like to display

    Summery
    -------------------

    alex has the job of Clerk in department 10 since 17-DEC-80



    Heres what i have done so far...


    select CONCAT(CONCAT(ename,' has held the job of ') , CONCAT(CONCAT(job,' In department '),deptno))
    from emp

    I am having problems with the last part, im using the HDATE colume and i wanna show the date they were hired but i keeps getting erros. . Can some someone show me using the concat function how I can achieve this by what i have done so far.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    select ename||' has held the job of '||job||' In department '||deptno||' since '||to_char(hiredate,'mm/dd/yyyy')
    from emp;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    May 2005
    Posts
    37

    Resolved

    Thanks beilstwh


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •