Home » SQL & PL/SQL » SQL & PL/SQL » Please Help to Solve this Query..
Please Help to Solve this Query.. [message #216811] Tue, 30 January 2007 09:47 Go to next message
achyut.k
Messages: 1
Registered: September 2006
Junior Member
Hi,
I have a table Emp_presence ,which have the follwing columns
Emp_code Varchar2(6),
Emp_name char (30),
Att_date Date ,
Att_time Varchar2(Cool.

The above table records the the The Inpunch and outpunch of Each Employee who comes into the factory
or goes out of the factory on each day (i.e Morning, Afternoon, and Evening).

When I try to Execute The script am getting the follwing output in 3 lines for Each Employee

EMP_CODE EMP_NAME ATT_DATE Time

E69761 MADHU 24-JAN-2007 07:56

12:30

16:22




But I want the output in follwing format in Single line for Each Employee

EMP_CODE EMP_NAME ATT_DATE Time 1 Time 2 Time 3


E69761 MADHU 24-JAN-2007 07:56 12.30 16:22



Waiting For Your Earliest Reply

Achyut k

  • Attachment: test.txt
    (Size: 0.96KB, Downloaded 143 times)
Re: Please Help to Solve this Query.. [message #216813 is a reply to message #216811] Tue, 30 January 2007 09:54 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Hi,

Maybe you should include the script Smile

Re: Please Help to Solve this Query.. [message #217439 is a reply to message #216811] Fri, 02 February 2007 03:39 Go to previous message
haikasi
Messages: 7
Registered: October 2006
Junior Member
hi,
under what column names does the inpunch and outpunch got
stored.
Previous Topic: Please correct this query for me
Next Topic: How to find how many occurences of every ID in table
Goto Forum:
  


Current Time: Fri Dec 02 22:45:38 CST 2016

Total time taken to generate the page: 0.08819 seconds