how to create object in plsql
Answers were Sorted based on User's Feedback
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 |
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
What is memory optimized table?
What are analytical functions in sql?
Write an sql query to select all records from the table?
How to run sql commands in sql*plus?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
What is java sql driver?
Does access use sql?
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
29 Answers Alps, Aricent, Bank Of America, Wipro,
Can you join views in sql?
What is forward declaration in pl sql?
What is a sql*loader control file?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)