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

Quote:

Originally Posted by 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?

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

Quote:

Originally Posted by amitpatel66

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

Quote:

Originally Posted by HARSHUL

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

Quote:

Originally Posted by debasisdas

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

Quote:

Originally Posted by 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?

Try TO_DATE function here:

check below query:

Expand|Select|Wrap|Line Numbers

 
Insert Into Student(name, Lastname, Birthdate,gender,chip)

  Values ('sue','chen',TO_DATE('29-02-1982','DD-MM-YYYY'),'f','3333');

For Oracle Sql plus

re: For Oracle Sql plus

re: For Oracle Sql plus

re: For Oracle Sql plus

re: For Oracle Sql plus

re: For Oracle Sql plus

re: For Oracle Sql plus

re: For Oracle Sql plus

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about