Oracle PL/SQL Datatype

Question

Learning about SQL datatypes in PL/SQL. I have a question about what datatype the following expression is:

temp := temp1 < (temp2/ 3);

I'm a bit confused on what datatype this may be. Datatypes can be Numeric, Characters, Boolean, Datetime, and Interval types but this one is throwing me off because of the expressions < and /. This makes me think it's Boolean but I'm not sure.

user330315 · Accepted Answer · 2013-01-22 08:11:10Z

7

It is a boolean. It's equivalent to:

boolean temp;
... 

if (temp1 < (temp2/3) then
  temp := true;
else
  temp := false;
end if;

answered Jan 22, 2013 at 8:11

user330315

Sign up to request clarification or add additional context in comments.

Comments

ibre5041 · Accepted Answer · 2013-01-23 21:25:22Z

0

Oracle is a little bit complicated in this case. SQL and PL/SQL are interpreted by two distinct engines. Each of them has it's own set of datatypes even if they look similar. Simply VARCHAR2 in SQL is something different from VARCHAR2 in PL/SQL. It gets a little bit more confusing when you start working collections. Also SQL does not have any datatype like BOOLEAN while PL/SQL does. The only exception is SQL function LNNVL which accepts a condition as a parameters, but anyway you can not use literals like "true" or "false" is SQL queries.

answered Jan 23, 2013 at 21:25

ibre5041

5,3261 gold badge24 silver badges40 bronze badges

Collectives™ on Stack Overflow

Oracle PL/SQL Datatype

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related