Which data type doesn't allow null data type?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
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
| Is This Answer Correct ? | 3 Yes | 10 No |
Can we create view in stored procedure?
What is a constraint?
Can we use two order by clause in query?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is structural independence and why is it important?
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
What is meaning of <> in sql?
Does mysql_real_escape_string prevent sql injection?
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;
What is the most common sql injection tool?
what eliminate duplicate without using roenum and not
What is partition by in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)