Problem in checking conditions
From: Karthick Ravi <erkarthickr_at_gmail.com>
Date: Sat, 8 Feb 2014 11:38:35 -0800 (PST)
Message-ID: <913245cf-0a1b-4f25-94f7-eca33a418bd3_at_googlegroups.com>
Hello Sir,
(ii) If there is an alternate way Please provide the basic code here.
Date: Sat, 8 Feb 2014 11:38:35 -0800 (PST)
Message-ID: <913245cf-0a1b-4f25-94f7-eca33a418bd3_at_googlegroups.com>
Hello Sir,
I'm using Oracle 10g for Educational purpose. I have only one table with five columns namely cusid,name,deposits and loan. Now when i create a check constrain using create assertion command i get error, When searching about it on web i found that create assertion command was in SQL-92 and no more in use. Was that true? can't we use assertions in Oracle 10g or Above?
If there is any alternate way to check,
(i) The total loan provided by loan should be always less than the total deposits made.
(ii) If there is an alternate way Please provide the basic code here.
Please reply as soon as possible.
Thanks in advance.
Karthi Received on Sat Feb 08 2014 - 20:38:35 CET