Is there any boolean type in Oracle database

0 votes
Is there any Boolean type in Oracle databases, similar to the BIT datatype in Ms SQL Server?
Oct 10, 2018 in Database by Frankie
 • 9,810 points • 130 views

1 answer to this question.

0 votes

Nope. I don't think there is one

But you can use:

IS_COOL NUMBER(1,0)

1 - true
0 - false
answered Oct 10, 2018 by Neha
 • 6,300 points

Related Questions In Database

0 votes
1 answer

What is checkpoint in Database?

Checkpoint declares a point before which all ...READ MORE

answered Sep 4, 2018 in Database by Sahiti
 • 6,360 points • 763 views
0 votes
1 answer

What is a Join in terms of database?

JOINS are used to combine rows from ...READ MORE

answered Nov 13, 2018 in Database by DataKing99
 • 8,240 points • 178 views
0 votes
1 answer

Which is the Preferred Method of Storing Passwords In Database?

Generally, we can use the sha hash ...READ MORE

answered Oct 11, 2019 in Database by Omaiz
 • 560 points • 307 views
0 votes
1 answer

Database Repair Options in Cassandra

Anti Entropy: Anti-entropy Repair is a process of ...READ MORE

answered Jun 28, 2018 in Database by kurt_cobain
 • 9,390 points • 818 views
0 votes
2 answers

Types of relationships in Database

There are 3 types of relationships in ...READ MORE

answered Aug 16, 2018 in Database by zombie
 • 3,790 points • 153 views
0 votes
1 answer

Indexes in Database

The index is a data structure that ...READ MORE

answered Aug 20, 2018 in Database by DataKing99
 • 8,240 points • 172 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by Parth
 • 4,630 points • 521 views
0 votes
1 answer

How can i copy tables from one database to other on AWS?

You can use AWS Data pipeline to ...READ MORE

answered Jul 5, 2018 in AWS by Priyaj
 • 58,080 points • 464 views
0 votes
1 answer

Automating Oracle script with nolio

Depending upon the details of your script ...READ MORE

answered Jul 17, 2018 in Other DevOps Questions by ajs3033
 • 7,280 points • 208 views
0 votes
1 answer

Is SELECT * harmful in Database?

There are really three major reasons: Inefficiency in ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
 • 8,240 points • 159 views
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.