select NVL(TIME_DIFF,'+0000') AS TIME_DIFF from my_table;
its a standard sql thingy
Daniel
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
Palanisamy Easwaran
Sent: Wednesday, December 08, 1999 4:56 PM
To: [EMAIL PROTECTED]
Subject: Getting Original column Name
Hi,
I do the following query using JDBC, after the query is executed I do get
resultset.
select NVL(TIME_DIFF,'+0000') from my_table;
I need the Original column name of the field TIME_DIFF as 'TIME_DIFF '
when I tried to use getColumnName(int) and getColumnLabel(int) which could
give
me only the field name as 'NVL(TIME_DIFF,'+0000').
Is there any way to get the actual SQL Table's field name?
thanks in advance,
eas
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
