Function

[informer30]

Hi All,

please can you advise how the following is possible?

select *
from table1
where
trunc(started) >= '09-Aug-2010'
and started < sysdate

The line
trunc (started) i.e. field is not even available in the table, how can this work I am lost?

Many Thanks

 

[carp]

You are right - if there is no column called started in table1, it will NOT work.

 

[informer30]

Thanks Carps...

Any second opinions...?

 

[Dagon]

It's total speculation without being able to see your database, but one possibility is that there is a function called started e.g.

CREATE OR REPLACE FUNCTION STARTED RETURN DATE IS
BEGIN
  RETURN SYSDATE;
END;
/

select * 
from DUAL
where
trunc(started) >= '09-Aug-2010'
and started < sysdate

For Oracle-related work, contact me through Linked-In.

 

[informer30]

that's brill dragon....

I will look into...

Many Thanks

 

[SantaMufasa]

that's brill dragon...

Although dragons may be brill, our friend and colleague, Dagon, is even more brill. <grin>

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[informer30]

Genuine mistake.....Santa...

 

[SantaMufasa]

Just "funnin' ya'" informer30.

Your boundless energy is admirable, too, informer.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”