how do i create a table without data type in oracle

Question

Is it possible to create a table having column but column without datatype.means is their any way to do it indirectly.if yes then plz give me one example

Answer 1

Hi subhransu,

As far as I know only columns have data types not tables.

Do you mean a table without columns?

Or do you mean a column without a specific data type?

A little more info would be helpful.

Answer 2

Oracle has 1 such table called dual. You can select any type from dual.

orafaq/wiki/dual

But it's hard to give you an exact answer. Maybe you can explain what you want to use this table for ?

Answer 3

No. Oracle columns always have a datatype, e.g. NUMBER, DATE, VARCHAR2, LOB.