Hi,
I want table structure shown below. How can i create this ?
Num Name Address
Addr1 Addr2
I want Addr1 and Addr2 under Address column.
How can i achive this ? Is it possible ?
Answers were Sorted based on User's Feedback
Answer / begum
hi this is really work
create type addr as object (
add1 varchar2(15),
add2 varchar2(15));
/
create table nest1 (
id number(2),
name varchar2(10),
address addr);
insert into nest1 values(10,'uma',addr('10th
main','bangalore'));
/
insert into nest1 values(20,'sami',addr('77g
colony','chennai'));
SQL> select * from nest1;
ID NAME
---------- ----------
ADDRESS(ADD1, ADD2)
--------------------------------------------
10 uma
ADDR('10th main', 'bangalore')
20 sami
ADDR('77g colony', 'chennai')
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / ashok
create table emp(num number(5),name varchar2(14),address
varchar2(15));
insert into emp values('&num','&name','&address');
Enter value for num:
Enter value for name:
Enter value for address: addr1 addr2
old 1: insert into emp values('&num','&name','&address')
new 1: insert into emp values('','','addr1 addr2')
Is This Answer Correct ? | 1 Yes | 12 No |
Use of an integrity constraint is better to validate data. Explain
if i am using dml statement in function. then i am writing select statement what was the output
How to use in conditions in oracle?
What are the sql clauses supported in the link property sheet ?
What does sharding mean?
what is the difference between simple view and complex view?
How to create an oracle testing table?
What are data pump export and import modes?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
How to assign values to variables?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.