create type type_name as object ( No NUMBER, Name Varchar2(15), City VA

how to create object in plsql

Question Posted / priya

Answer Posted / priya

create type type_name as object
(
No NUMBER,
Name Varchar2(15),
City VARCHAR2(30,
POSTALCODE CHAR()
);

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I remove sql plus from windows 10?

1086

Is sql easier than java?

1002

What are the different types of tables in sql?

994

what is the stuff function and how does it differ from the replace function? : Sql dba

1036

What is sqlca in powerbuilder?

1000

What type of join is sql join?

971

What are the different operators available in sql?

994

What does desc stand for?

1063

What information is needed to connect sql*plus an oracle server?

1018

How do you write a complex sql query?

1050

what is a composite key ? : Sql dba

1043

What is crud stand for?

992

What is consistency?

1112

What is the plv (pl/vision) package offers?

1040

What packages are available to pl/sql developers?

1040