0's and Decimal Point in Oracle SQL
939870May 25 2012 — edited May 25 2012hi,
Im using Oracle Sql developer 'Oracle Database 11g Enterprise Edition Release 11.1.0.6.0' (i'm fairly new), im having trouble inserting "0's before the 1" into the table and also with the decimal point
i've created a table with the following:
CREATE TABLE Employee
(Employee_ID number(4,0) NOT NULL primary key,
L_Name varchar2 (15),
F_Name varchar2 (10),
Pay_Rate number (5);
Then tried to insert this: insert into employee
values ('003', 'Clarke', 'Michael', '13.00');
which was sucessfull but when i used the select the query to view the table the result was not the same
result:
Employee_ID L_Name F_Name Pay_Rate
1 Clarke Michael 13
How can i make it so that the result shows up like this (001 and 13.00):
Employee_ID L_Name F_Name Pay_Rate
001 Clarke Micheal 13.00
Edited by: 936867 on May 25, 2012 8:15 PM
Edited by: 936867 on May 25, 2012 8:18 PM