Answer Posted / chandu
create type addresstype as object
(hno varchar2(5),street varchar2(10),
city varchar2(10),pin varchar2(5));
Now we use this object in creating table like this.
create table employee(empno number(5),job varchar2(10),sal
number(5),empaddress addresstype);
insert into employee
values(101,'clerk',6000,addresstype('114a','gandhi','hyd',50001));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a clob in sql?
What is sql select statement?
What is rtm stands for?
Mention what pl/sql package consists of?
What are the different operators available in sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What are different types of tables in sql?
What is percent sign in sql?
what is the command line end user interface - mysql? : Sql dba
How do I write a sql query in pgadmin 4?
How many sql core licenses do I need?
How do I use google cloud in sql?
What is an ndf file?
Is oracle and sql same?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
