CREATE TYPE |
Créer un type |
---|---|
Oracle Database SQL |
Syntaxe
CREATE TYPE type_name AUTHID [CURRENT USER | DEFINER] AS OBJECT ( attribute attribute data_type, inheritance clause, subprogram spec) [FINAL | NOT FINAL] [INSTANTIABLE | NOT INSTANTIABLE]; |
CREATE TYPE type_name AS OBJECT ( column_name data_type, ..., column_name data_type); |
CREATE TYPE type_name AUTHID [CURRENT USER | DEFINER] UNDER supertype_name, attribute data_type, inheritance clause subprogram spec, pragma clause) [FINAL | NOT FINAL] [INSTANTIABLE | NOT INSTANTIABLE]; |
Description
Cette instruction permet de créer un type d'objet.
Voir également
Article - Les géants de l'informatique - Oracle
Dernière mise à jour : Lundi, le 11 mai 2015