Help with SQL

Hi, can someone please help me with the following.

Say this was my code:

CREATE TABLE person
(
name VARCHAR2(30),
dob DATE
);

First question. How do I make everything entered into the name field UPPERCASE?

secondly, how would I insert a date using the following code:

INSERT INTO person VALUES
('mike', '1987-03-17');

This format results in an error!

thanks for all your help.
Adam

First answer: with a trigger, if your mysql version supports them, but I'd not bother about this and simply convert everything to uppercase when retrieving
Second one: check the manual for the proper date format

you would do it exactly like that

are you sure you are running mysql?

mysql doesn't support VARCHAR2, so i don't think you would have been able to create that table

INSERT INTO person VALUES
('mike', '1987-03-17');Depending on the current setting of NLS_DATE that is (if it is indeed Oracle)

I am using varchar2 so maybe not mysql? what version of SQL would it be?

Also, how do i create a composit key?

This results in errors:

CREATE TABLE person
(
name VARCHAR2(30),
phone char(11)

PRIMARY KEY (name, phone)
);

thanks again.

First of all confirm if you are on mysql or another database

It must not be, it's called iSQL *plus

Which forum do I post in? Is it MS SQL?

thanks

Google would tell you that iSQL*plus is for Oracle (read more here , ask a mod to move this thread there.
Then read about oracle's to_date()

isql is come with oracle and it is being use in the oracle enterprise manager web environment. Most of the time dba will just turn that service off to save some resources since most dba are comfortable using just sqlplus.