SQL in oracle enterprise edition

[jim larkin]

I am have a problem with sql iam new to this and dont know what is with the
code i used please let me know if you see where
SQL>
Wrote file afiedt.buf

1 insert into ROLLBAR_JLL
2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
3 birthdate)
4 values
5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
6* 'm',15.25,'y',05/21/79)
SQL>
1 insert into ROLLBAR_JLL
2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
3 birthdate)
4 values
5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
6* 'm',15.25,'y',05/21/79)
'm',15.25,'y',05/21/79)
*
ERROR at line 6:
ORA-00932: inconsistent datatypes

[Krishna]

Hi Jim,

I think you are missing a single quotation mark. Try with the following codes.

insert into ROLLBAR_JLL
(first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,birthd ate)
values
('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
> 6* 'm',15.25,'y',05/21/79)
"jim larkin" <j759ll@stargate.net> wrote:
>
>I am have a problem with sql iam new to this and dont know what is with
the
>code i used please let me know if you see where
>SQL>
>Wrote file afiedt.buf
>
> 1 insert into ROLLBAR_JLL
> 2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
> 3 birthdate)
> 4 values
> 5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
> 6* 'm',15.25,'y',05/21/79)
>SQL>
> 1 insert into ROLLBAR_JLL
> 2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
> 3 birthdate)
> 4 values
> 5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
> 6* 'm',15.25,'y',05/21/79)
>'m',15.25,'y',05/21/79)
> *
>ERROR at line 6:
>ORA-00932: inconsistent datatypes

[Krishna]

Hi Jim,

Sorry, there was some problem with the last message. Any try using the following
codes.

insert into ROLLBAR_JLL(first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uni form,birthdate)
values
('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
'm',15.25,'y','05/21/79')



Cheers.


Krishna Pada Das
MCDBA


"jim larkin" <j759ll@stargate.net> wrote:
>
>I am have a problem with sql iam new to this and dont know what is with
the
>code i used please let me know if you see where
>SQL>
>Wrote file afiedt.buf
>
> 1 insert into ROLLBAR_JLL
> 2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
> 3 birthdate)
> 4 values
> 5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
> 6* 'm',15.25,'y',05/21/79)
>SQL>
> 1 insert into ROLLBAR_JLL
> 2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
> 3 birthdate)
> 4 values
> 5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
> 6* 'm',15.25,'y',05/21/79)
>'m',15.25,'y',05/21/79)
> *
>ERROR at line 6:
>ORA-00932: inconsistent datatypes

[Bill Hullsiek]

Oracle is not interpreting the date string 05/21/79 correctly.
I do not have my manuals, but there is a function to convert
a character string to a date-time datatype or a date data-type
correctly.




"jim larkin" <j759ll@stargate.net> wrote:
>
>I am have a problem with sql iam new to this and dont know what is with
the
>code i used please let me know if you see where
>SQL>
>Wrote file afiedt.buf
>
> 1 insert into ROLLBAR_JLL
> 2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
> 3 birthdate)
> 4 values
> 5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
> 6* 'm',15.25,'y',05/21/79)
>SQL>
> 1 insert into ROLLBAR_JLL
> 2 (first_name,last_name,address,zipcode,phone#,position,ss#,mar_stat,hrlyrate,uniform,
> 3 birthdate)
> 4 values
> 5 ('mary','jelson','1180 chelton dr pgh pa','15211','412-883-2798','waiter','181-54-8811',
> 6* 'm',15.25,'y',05/21/79)
>'m',15.25,'y',05/21/79)
> *
>ERROR at line 6:
>ORA-00932: inconsistent datatypes