| Duchi |
Posted: May 29, 2008 09:45:05 AM |
Total Post: 12
Joined: Jan, 2008
|
I'm loading the data into a table using sql loader
Is there a way I can query the datbase to find the day the rows got populated? the table does'nt have any date columns, so I have to query the database to find the day the rows were populated
appreciate your help
Thanks
|
|
|
 Geetha |
| Posted: May 29, 2008 11:25:29 AM |  |
|
Total Post: 24
Joined: Mar, 2008
|
hi...
You couldnt find date until unless you populate the sysdate along with the data to the table.
|
|
|
|
|
| Duchi |
| Posted: May 29, 2008 11:32:50 AM | |
|
Total Post: 12
Joined: Jan, 2008
|
thank you for the response
|
|
|
|
|
| Gitesh |
| Posted: May 29, 2008 10:52:06 PM | |
|
Total Post: 322
Joined: May, 2005
|
create trigger on same table for temporary use,you will get your all.
|
|
|
|
|
| snehalatha |
| Posted: May 30, 2008 05:32:24 AM | |
|
Total Post: 169
Joined: Apr, 2006
|
Hi,
Create a Trigger on the table and insert into the temporary table which are created newly or updated on the day
every day you have to refreh the temp table.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
