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
- 4577 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
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to install oracle database 10g xe?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Can we connect to ORACLE db using Windows Authentication?
How to shutdown your 10g xe server from command line?
How do I start tns listener?
how to clone 9i Database on to 10g Database.
What is oracle latest version?
What is the quickest way to fetch the data from a table?
What is rowid and rownum in oracle?
What is java oracle used for?
What language does oracle use?
Difference between open_form and call_form in oracle.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
