java_roshan

First, I am surprised, that there are no sections of database related sections..

How?

It it the thing that drives everything...right?

My query....

I type a check constraint for a table as

check(dob < sysdate)...

I encountered an error stating that the system variable is wrongly used.
I have checked this and found that I might need to write this...

check (dob < ROUND(sysdate) )
Is this correct?

__________________
Visit: http://www.somaiya.edu

bl00dninja

i believe this was addressed in some other post. the site leaders' point of view was that most questions in this area tend to be of the type "how do i use 'whatever language' to interact with a database?" making most of these queries fall neatly into one of the existing forums. however, i personally believe that it wouldn't hurt to have an SQL forum.

__________________
i put on my robe and wizard hat...

Have you ever heard of Plato, Aristotle, Socrates?...Morons.

Dizzutch

I do a lot of work with Oracle, 9i and 10g, I'll look into your problem tonight, and get back to you if nobody else does first.

__________________
naked pictures of you | PFO F@H stats

Infinite Recursion

Same here, primarily 9i and 10g development... in a pl/sql environment... but I'll look into this as well, as I have access to older databases at home.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

DaWei

Wrong. Much, yes, but your view is narrow.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

java_roshan

I think I should have been precise....

It is something that has to be behind something...

I hope I am not narrower now?
:-?

__________________
Visit: http://www.somaiya.edu

DaWei

There are tons of applications that don't deal with databases, either directly or indirectly. Of course, they deal with data (what position is switch #2 in?), but that's hardly a requirement for Oracle or any other "database."

There would be, I'm sure, forums for databases generally, or specifically, if the traffic warranted them. For instance, if had a problem with a particular query to MySql, I'd no doubt encounter it in my PHP's code, and ask in the PHP forum, even if it were strictly a MySql mistake. If there were tons of such things, a database (or even a MySql) forum would no doubt spring into existence to satisfy the need.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

java_roshan

DaWei Sir,

Kindly give me examples of those applications that do not deal with databases directly or indirectly...
the reason I am asking this, is because, I really dont know ...

Also, what is the answer to my query (#1 sysdate..??)

__________________
Visit: http://www.somaiya.edu

Infinite Recursion

An example that doesn't necessarily require a database is: Client/Server programming. You don't need to have a database to remotely monitor another machine, etc.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

Infinite Recursion

how about trying this ...

CHECK ((To_Date(dob)) < SYSDATE ) ?

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."