Hi ,
(1) How can I convert the database developed using Microsoft Access to a Oracle
Database,Without writing each and every script t create tables and store data.
-- Create a DNS for Oracle Database Schema ( Database , User ID , Password ) &
-- Use Ms - Access Import Tables Option to import data from Ms- Access to Oracle
Tables .
(2) I do use java.sql.Date in my project but by any chance if I want to
compare the system date with the already strored date in my project. How can
I do it.
Because If I get the system date it consists of many fields where as what I
stored in my db is only of yyyy-mm-dd format.
-- Use To_date SQL Function to convert the Sysdate into the desired format you want
Ex : Select to_date(syadate,yyyy-mm-dd) from table .
Ravi
Tom John wrote:
> Hi,
> I do have Two questions
>
> (1) How can I convert the database developed using Microsoft Access to a Oracle
> Database,Without writing each and every script t create tables and store data.
>
> (2) I do use java.sql.Date in my project but by any chance if I want to
> compare the system date with the already strored date in my project. How can
> I do it.
> Because If I get the system date it consists of many fields where as what I
> stored in my db is only of yyyy-mm-dd format.
>
> Thanks in Advance
>
> TOM
>
> ___________________________________________________________________________
> 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
--
**************************************************************
Ravi Shankar Reddy Pachipala
Sr. Systems Engineer
Wipro Technologies
1-8-448 , Lakshmi Building ,
S.P. Road , Begumpet
Secunderabad -500 003, India
Tel: 91-40-7896008
Fax: 91-40-7896123
E-mail:[EMAIL PROTECTED]
www.wipro.com
The World's First SEI CMM Level 5 Software Services Company
**************************************************************
___________________________________________________________________________
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
