Answer / krishna kant kumar

SIMPLE_INTEGER

Answer / shailesh

First of all the way this question is asked is totally wrong. The learner may have to ask which data type does not allow null values.

All data types will allow to insert null values unless the Primary Key or Not Null constraint is defined on a column.

Answer / anil

not null,Primary key

Answer / rajesh

The first answer is wrong, because 'NULL' is string its not null.

If u give null in insert query as second parameter the row will be inserted.

Answer / mathivanan

NATURALN,POSITIVEN,SIMPLE_INTEGER

Answer / nanne saheb c

Can't insert NULL value in DATE data type. Please find the below practical as example.

CREATE TABLE Example(
name VARCHAR(30),
regist DATE,
PRIMARY KEY(name)
);

INSERT INTO Example VALUES ('anyname','NULL');

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Which is better join or inner query?

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

What is the difference between an inner and outer join?

0 Answers  

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

How many types of privileges are available in sql?

0 Answers  

How to test for null values?

0 Answers  

How many types of triggers are there in pl sql?

0 Answers  

How to run sql*plus commands in sql developer?

0 Answers  

What are the benefits of pl sql?

0 Answers  

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

what is a tablespace? : Sql dba

0 Answers