For Oracle Sql plus

[HARSHUL]

One table contains information about courses offered at a local college. A course number like MATH1301 or HIST2311 identifies each course. All course numbers are the same length. Each course has a name and number of credit hours earned for successful completion of the course. All information in this table is mandatory. The values stored in the credit hours must be greater than zero and less than 100.


check this
and how can u make this possible?

[amitpatel66]

One table contains information about courses offered at a local college. A course number like MATH1301 or HIST2311 identifies each course. All course numbers are the same length. Each course has a name and number of credit hours earned for successful completion of the course. All information in this table is mandatory. The values stored in the credit hours must be greater than zero and less than 100.


check this
and how can u make this possible?

You can add NOT NULL constraint on all the columns of the table
ADD CHECK constraint for credit hours to be between 0 and 100

[HARSHUL]

You can add NOT NULL constraint on all the columns of the table
ADD CHECK constraint for credit hours to be between 0 and 100

I did Not Null
but add check constraint right?
but in coding i am doing but now it is giving me an error
i check that but it is not working

[amitpatel66]

I did Not Null
but add check constraint right?
but in coding i am doing but now it is giving me an error
i check that but it is not working

Can you PSOT your error number and error message for my reference?

[debasisdas]

Kindly post the table structure for reference of our experts.

[HARSHUL]

Kindly post the table structure for reference of our experts.

Part 2. Insert the following data into the three tables
Chip name DOB Dep Course title hrs
1234 Bob Smith 11Dec1953 M 3 Math1314 Algebra 3 B
1111 Sally M Jones 1 June 73 F 5 Math1314 Algebra 3
1111 Sally M Jones 1 June 73 F 5 HIST1301 US 3 B
1234 Bob Smith 11Dec1953 M 3 Hist1301 US 3 A
PHED1109 Yoga 1
2121 Al A Ala 6Novem83 M PHED1108 Dance 1
3333 Sue Chen 29 Feb 82 F 0

[HARSHUL]

Insert Into Student(name, Lastname, Birthdate,gender,chip)
Values ('sue','chen', '29-02-1982','f','3333');

When I Trying To Put Date
Month Feb
But It Is Not Working It Is Giving Me Error No

Ora-01830

And I Tried With 02
Then Giivng Me One More Error
Ora-01843
So Any Sugestion?

[amitpatel66]

Insert Into Student(name, Lastname, Birthdate,gender,chip)
Values ('sue','chen', '29-02-1982','f','3333');

When I Trying To Put Date
Month Feb
But It Is Not Working It Is Giving Me Error No

Ora-01830

And I Tried With 02
Then Giivng Me One More Error
Ora-01843
So Any Sugestion?

Try TO_DATE function here:

check below query:

Insert Into Student(name, Lastname, Birthdate,gender,chip)
  Values ('sue','chen',TO_DATE('29-02-1982','DD-MM-YYYY'),'f','3333');