How to insert a float value in a table in SQL and how to creating a view of this table

Question

2.50/5 (2 votes)

See more:

I already have a table whose name is EMP_DETAILS. It has 3 column, one is NAME (VARCHAR2(150)), EMP_ID(NUMBERS(5,0)) and another one is SALARY(INTEGER(5,0)). I want to alter the datatype of column SALARY to FLOAT.

Primary Key is EMP_ID.

For that t wrote a query which is, ALTER TABLE EMP_DETAILS MODIFY SALARY float(5,0);

When ever I want to insert some value into this table I didn't insert any value into this.

Actually I want to Know what is the syntax to get the float value.

Posted 15-Dec-14 3:29am

Bittu14

Updated 15-Dec-14 4:51am

v5

Add a Solution

Comments

DamithSL 15-Dec-14 10:11am

do you have unique or primary key in EMP_DETAILS table?

ZurdoDev 15-Dec-14 10:40am

The error seems pretty clear. You're trying to insert duplicate data. So, what is the question exactly?

Bittu14 15-Dec-14 10:49am

Yes I know that. But I tried the bellow query:

ALTER TABLE EMP_DETAILS
MODIFY SALARY float(5,0);

Is there is any syntactical error?

ZurdoDev 15-Dec-14 10:50am

What happens when you try to do this?

Bittu14 15-Dec-14 10:53am

Then the error was occurred. That is:
Error starting at line : 37 in command -
ALTER TABLE EMP_DETAILS
MODIFY SALARY float (5,0)
Error report -
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:

ZurdoDev 15-Dec-14 11:06am

I don't do Oracle but it would appear you just have a syntax issue. I'd suggest googling for the correct syntax.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-12-15T06:30:00

Solution 1

Note, that FLOAT is a floating-point number with a binary precision, so you can't set the number of digits before and after the decimal.
See:
https://docs.oracle.com/cd/B28359_01/server.111/b28285/sqlqr06.htm#CHDJJEEA[^]
http://psoug.org/definition/FLOAT.htm[^]

Posted 15-Dec-14 6:30am

Maciej Los