adspace


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

how to escape special characters in sql statements? : Sql dba

1124


what is sql server agent? : Sql dba

1189


Can delete statement be rollbacked?

1065


what is schema? : Sql dba

1163


what is dbms? : Sql dba

1070


How do I remove duplicates in two columns?

1202


Is primary key clustered index?

1028


What is the current version of sql?

1106


how to use regular expression in pattern match conditions? : Sql dba

1125


how many tables will create when we create table, what are they? : Sql dba

1156


how to start mysql server? : Sql dba

1279


Is primary key always clustered index?

1101


what are all the common sql function? : Sql dba

1141


Is inner join faster than left join?

1287


If a cursor is open, how can we find in a pl/sql block?

1252