NUMBER and nullable data type

Ranch Hand

Posts: 375

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If I have a column "value" and its data type is "NUMBER(10,3)" and it is "nullable". How do I insert a null value for it ? If it is a "varchar2" type I can set "null", how to set for "NUMBER" ?

maybe a silly question.. Sorry.

Jeanne Boyarsky

author & internet detective

Posts: 42148

937

I like...

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ben,
Without quotes around it, null is a keyword that you can use in a query.

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Don't get me started about those stupid light bulbs.