how to create object in plsql

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between syntax and runtime errors.

635


What are different types of sql?

553


What does select * from mean in sql?

1981


how can we repair a mysql table? : Sql dba

534


what is the use of set statement in tsql? : Transact sql

523






Explain the select statement in sql?

611


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

528


What normalization means?

520


What is multiple columns?

567


What is the use of sqlerrd 3?

515


What is a sql driver?

521


What are the most important characteristics of pl/sql?

570


What is the difference between partitioning and sharding?

523


What has stored procedures in sql and how we can use it?

561


What is Difference Between Unique and Primary Key Constraints?

602