|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
|
|
#1
April 4th, 2008, 01:24 PM
|
|||
|
|||
|
Alter session
hi friends,
I am happy with last answer. I am doing alter session set NLS_DATE_FORMAT='MM-DD-YYYY' in TOAD. I need the date in the above format.When i am inserting 50,000 records into table its working fine.I am getting correct date format. When i am trying to insert more data i.e more than 50,000 records .There is a problem with date format. Ex  ld data contains date 1943 ,after inserting to new table i am getting date as 2043. Please help me in this process.Is any other process for this???? chockyyy
|
|
#2
April 9th, 2008, 02:12 PM
|
|||
|
|||
|
Alter Session
Hello,
I am able to do this by alter session statement in the procedure.So when we run the procedure this statement should run and solved the problem. Thanks chockey
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Alter session |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
