Help with a if statement

Dev Shed Forums Sponsor:

December 2nd, 2011, 06:48 AM

Coe1ho

Registered User

Join Date: Dec 2011

Posts: 3

Time spent in forums: 1 h 19 m 28 sec
Reputation Power: 0

Help with a if statement

hey guys, i'm new here and am stuck with a bit of sql.

i've got a project and im wondering whether it is possible to create an if statement that says something like

"If column A is NOT NULL then column B cannot be NULL"

would I have to do this as a trigger or a constraint? any help would be greatly appreciated!

cheers

December 2nd, 2011, 07:13 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,701

Time spent in forums: 1 Month 3 Weeks 4 Days 2 h 17 m 41 sec
Reputation Power: 284

Code:

CREATE TABLE foobar
(
   foo integer,
   bar integer,
   constraint check_not_null check (foo is null or (foo is not null and bar is not null))
);

December 2nd, 2011, 07:37 AM

Coe1ho

Registered User

Join Date: Dec 2011

Posts: 3

Time spent in forums: 1 h 19 m 28 sec
Reputation Power: 0

thanks, works fine

Viewing: Dev Shed Forums > Databases > Oracle Development > Help with a if statement

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump