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 ?
- 2 Answers
- 4537 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to define an oracle cursor variable?
What happens to the current transaction if a ddl statement is executed?
What are ddl statements in oracle?
How to rename an index?
What is an anonymous block?
How to assign a tablespace to a users in oracle?
What are the parameters that we can pass through a stored procedure?
How to connect ms access to oracle servers?
Explain the blob datatype?
what is the scenario where you take the database to NoArchivelog mode?
Is there any function in oracle similar like group_concat of mysql?
What is connection pool in oracle?
Differentiate between pre-select and pre-query?
What are the varoius components of physical database structure of oracle database?
What are the different pseudo commands? Explain in general?
