Question

Restricting Rows And Sorting Data

Discuss the differences in handling different datatypes when including conditions in a query.

Oracle 12c: SQL

Answer 1

Answer)

In the SQL there are many types of datatypes and each one's handling is different when including conditions in a query as:

CHARACTER [(length)] or CHAR [(length)] - Use using single quotes in the char as for example: select * from tablename where attributename='John';

VARCHAR (length) - Use using single quotes in the char as for example: select * from tablename where attributename='John'; where attributename is of varchar type and we are comparing a value with it.

BOOLEAN - No use of any quotes and can simple compare with Boolean values as true or false. SELECT * FROM tablename WHERE attributename = false; attributename is of BOOLEAN type

SMALLINT - No quotes or anything to be used. Can simply compare numbers using operators such as < , < , = etc.

SELECT * FROM tablename WHERE attributename = 2; attributename is of SMALLINT type

INTEGER or INT - No quotes or anything to be used. Can simply compare numbers using operators such as < , > , = etc.

SELECT * FROM tablename WHERE attributename = 2;

attributename is of INTEGER type

FLOAT(p) - matching a float column is as simple as just placing the float value like: SELECT * FROM tablename WHERE attributename = 2.3;

DATE - matching a date using just the date in single braces as:

SELECT * FROM tablename WHERE attributename >= '20081220 00:00:00.000';

This depends on the date format.