how to create object in plsql

Question Posted / deepus

Answers were Sorted based on User's Feedback

how to create object in plsql..

Answer / ayan banerjee

create type type_name as object
()

Is This Answer Correct ?

9 Yes

0 No

how to create object in plsql..

Answer / 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

More SQL PLSQL Interview Questions

what is explain plan?

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

What can I use instead of union in sql?

What is the fastest way of accessing a row in a table?

How well can multiple sessions access the same data simultaneously ?

is it mandatory to select all the column in a view then what columns should be selected

Is keyword pl sql?

What is the diffrence between IN and EXISTS.which one is faster.

what is the difference between truncate and drop statements? : Sql dba

What is structural independence and why is it important?

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

What are the popular database management systems in the it industry?

For more SQL PLSQL Interview Questions Click Here