OraFAQ Forum: SQL & PL/SQL » Syntax for creating oracle type

Home » SQL & PL/SQL » SQL & PL/SQL » Syntax for creating oracle type (Oracle 11g )

Mon, 29 December 2014 16:14

Oracle_Walker
Messages: 71
Registered: January 2012
Location: United States

Member

Hi,

I need to create a new type in my database. I am using the below command to create the same,

create or replace type tabtype as table of number;

But I would like to know the exact syntax for the same. Please help.

Mon, 29 December 2014 17:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails, Read The Fine Manual yourself

https://docs.oracle.com/database/121/SQLRF/toc.htm

Previous Topic:	Problem with nested FOR Loop
Next Topic:	How to select distinct sql_id together with clob column

Goto Forum:

]

Current Time: Fri Apr 26 04:18:52 CDT 2024