Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
    Bookmark Topic Watch Topic
  • New Topic

sql doubt  RSS feed

 
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi everyone
please explain he meaning of following sql command

alter table Customers add check(Credit_Limit<10001);

and this is the customer table---

create table Customers
(
CustNo number(4) primary key,
First_Name varchar2(30) not null,
Last_Name varchar2(30) not null,
CustType char(1) not null,
Credit_Limit number(7,2),
Credit_Card_No number(16),
Credit_Card_Type varchar2(8)
);
 
Live ordinary life in an extraordinary way. Details embedded in this tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!