DSXchange

Makes sense, Thanks Craig

Nice replies craig and thebird.
Craig, do i need to pass TO_DATE('12/01/2006','MM/DD/YYYY') if i have to override? is there no way i can pass just 12/01/2006 or 12-01-2006

The date can change sometimes, that is the reason why i want to parameterise it.
Craig, Can I use TRUNC(SYSDATE-1) as a parameter value?
How do i give the default value of the parameter as yesterday's date?
If the date changes i should be able to give another date.

Hello everybody My database is Oracle. I have a table which has a date column. I want to query against it to get data for yesterday's date, which is already available in the table. I can do this using an oracle query, but I need a way to pass yesterday's date as a parameter to a SQL query in Oracle ...

Do an exact search on "abort a job" you get many results.

Thanks for the info.

So does it mean that we can get the usage analysis for jobs refering to a particular table,

before we have saved the metadata and after we have saved?

Or it it only moving forward, after the save is done?

Just curious. Did you try Usage Analysis, did it not help? Hello Narasimha, Unfortunately, We have not used the metadata defintions in manager. So cannot use the same to track the job. I think your suggestion should help incase we had the metadata defintion defined. Thanks. Can we save the metadata...

Chicken! Thats a good idea

goriparthi wrote: OK CRAIG

Hey dont get it wrong,

All Craig wanted to say was, is writing in UPPER case is like shouting.

You are doing it again!