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

Can we create view in stored procedure?

0 Answers  

What is a constraint?

0 Answers  

Can we use two order by clause in query?

0 Answers  

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

What is structural independence and why is it important?

0 Answers  

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

What is meaning of <> in sql?

0 Answers  

Does mysql_real_escape_string prevent sql injection?

0 Answers  

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

What is the most common sql injection tool?

0 Answers  

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

What is partition by in sql?

0 Answers