MariaDB 10.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SET SQL_MODE='ORACLE';
CREATE TABLE USERS
(
    ID          NUMBER(4)    NOT NULL PRIMARY KEY,
    NAME        VARCHAR2(20) NOT NULL,
    DEPTO       VARCHAR2(20) NOT NULL
);
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'USERS'


TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
COLUMN_DEFAULT
IS_NULLABLE
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION
NUMERIC_SCALE
DATETIME_PRECISION
CHARACTER_SET_NAME
COLLATION_NAME
COLUMN_TYPE
COLUMN_KEY
EXTRA
PRIVILEGES
COLUMN_COMMENT
IS_GENERATED
GENERATION_EXPRESSION


def
fiddle
USERS
ID
1
null
NO
decimal
null
null
4
0
null
null
null
decimal(4,0)
PRI

select,insert,update,references

NEVER
null

def
fiddle
USERS
NAME
2
null
NO
varchar
20
20
null
null
null
latin1
latin1_swedish_ci
varchar(20)


select,insert,update,references

NEVER
null

def
fiddle
USERS
DEPTO
3
null
NO
varchar
20
20
null
null
null
latin1
latin1_swedish_ci
varchar(20)


select,insert,update,references

NEVER
null

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	ORDINAL_POSITION	COLUMN_DEFAULT	IS_NULLABLE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	DATETIME_PRECISION	CHARACTER_SET_NAME	COLLATION_NAME	COLUMN_TYPE	COLUMN_KEY	PRIVILEGES	IS_GENERATED	GENERATION_EXPRESSION
def	fiddle	USERS	ID	1	null	NO	decimal	null	null	4	0	null	null	null	decimal(4,0)	PRI	select,insert,update,references	NEVER	null
def	fiddle	USERS	NAME	2	null	NO	varchar	20	20	null	null	null	latin1	latin1_swedish_ci	varchar(20)		select,insert,update,references	NEVER	null
def	fiddle	USERS	DEPTO	3	null	NO	varchar	20	20	null	null	null	latin1	latin1_swedish_ci	varchar(20)		select,insert,update,references	NEVER	null