| creating a condition using sql [message #374331] |
Wed, 06 June 2001 09:14 |
LEVIATHAN
Messages: 8
Registered: June 2001
|
Junior Member |
|
|
Is it possible to create a condition using sql. I am new to programming so I think I would prefer to use a trigger at this stage (more so since I dont know how to use one).
Basically I want to create a condition where a value in a column and row(for example in the row for Andrew, the column title amount_owing) in one table can only be entered on the candition that a column in another table demonstrates he is owing money.
An If/then/else statement comes to mind but I dont think that can be done with sql*plus..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
