|
View previous topic :: View next topic
|
| Author |
Message |
Gousiya Mulla
New User
Joined: 02 Jun 2008
Posts: 87
Location: Bangalore
|
|
|
|
1. How can we increase the length of column .
Me : If it is in production we need to take the back up of the existing data (with complete plan to re-process that data back to production) , and modify the table using alter option .
2. How can we add columns in middlle of the table .
Me : If it is in production we need to take the back up of the existing data (with complete plan to re-process that data back to production) , and redefine the table (probably REORG)
3. Without using 'WHERE' condition , how can we retrieve colums having NULL values ??
4. How to retrieve yesterday's date ?
Me : We can do this using currentdate-1 . This might be saved in the predefined tables .
But I am not sure which table . SQL for this please ?
It would be great if you could provide your comments on this . |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Gousiya ,
I would suggest you to read the manual. It seems that you need to brush up your skills. |
|
| Back to top |
|
|
Gousiya Mulla
New User
Joined: 02 Jun 2008
Posts: 87
Location: Bangalore
|
|
|
|
| Sure ... thanks !! |
|
| Back to top |
|
|
ms0033436
New User
Joined: 20 Nov 2008
Posts: 15
Location: Pune
|
|
|
|
| thanks |
|
| Back to top |
|
|
|
|
