how to copy table from other database in oracle
In the past, I had difficulty in copying tables from other database both using oracle. I didn't know that it is just so simple, using this code:copy from username1/passwd1@tnsname1 - to username2/passwd2@tnsname2 - insert username2.table2 (table2_column1, - table2_column2, ..., table2_columnn) - using select table1_columna, table1_columnb, - ..., table1_columnx - from table1 where .... ;note: tnsname1 is the source database, table1 is the source table, tnsname2 is the destination database, table2 is the destination table. How to make a summary table from many tables? From the above code, just change the query by adding other table name, the columns and how the tables joining or grouping is made. For example:
copy from username1/passwd1@tnsname1 - to username2/passwd2@tnsname2 - insert username2.summ_employee_sallaries (name, id, - position, sallary) - using select E.employee_name, E.employee_id, - S.position_desc, S.amount - from employees E, sallaries S - where E.employee_position_id=S.position_id;The above code shows that employee sallary depends on employee position (though usually in the real world same position doesn't mean you will get the same amount of sallary, right?). Remember, all destination columns should be included in the code, or it won't work.
posted by kus @ 8:08 AM
33 Comments:
Creative blog. I thought it was the best site out
and we had to go back to it! Every chance I get on the
net I search for blogs just like your site.
I was in love with your in job pharmacy sc blog site.
Terrific blog. I search the internet everytime I
get a moment to find blogs. Its better than cold iced
tea and I have to visit it one more time!
If your look to uncover information, please visit my find a job blog
Awesome blog. I'm loving the site and I have to
return there soon! Going online, when I have the time,
I look for blogs close to your work!
I want you to stop and compare with my 2nd canada loan mortgage blog.
Excellent blog. I go though the web in search of
blogs like this one. Its so good, that I plan on
returning to its site!
I will give you access to jump to my blog.
I surf the web looking for blogs like this one.
Your site was on point and will be back again! Awesome
blog.
Look who checking out my 2nd home loan mortgage blog?
Super blog. I enjoyed the site and when I have the
time, shall visit the site again. Finding blogs this
good on the internet.
You must peep out my 2nd mortgage loan colorado blog.
Inspiring blog. I love finding blogs this good on
the internet, when I have the time. I'm going to go
back to it!
Search for my Home Purchase blog, it will leave you speechless.
Excellent blog. It was so great and I bet I will
go back to it! I get to look online for blogs like
yours is a blessing.
Hey why don't you peep my Second Mortgage blog site.
Unusual blog. I liked the site its from so much I
have to visit it again! I surf the web for blogs like
yours in my spare time.
In an efford of finding the right info, check for my home equity 2nd mortgage loan blog site.
Incredible blog. I admired your site and I will be
back once again to view it! I use much of my spare
time searching for blogs like yours.
Go and click my Home Purchase blog.
Captivating blog. I love surfing the web for the
type of blogs that you do. It had me on the edge of my
seat and I kept going back to again and again!
Sweetie, go and search my 125 2nd loan mortgage blog for what you need.
Great blog. I just like the site and I will get a
visit again! In my spare time I usually try and look
for blogs just as neat as yours.
Where you been? You have got to look at my Home Equity Mortgage blog!
Unbelievable blog. I can hardly wait to vist this
site again.I'm consistently looking up blogs like
this.
Once you sign on, check for my 2nd mortgage loan blog.
Captivating blog. I love surfing the web for the
type of blogs that you do. It had me on the edge of my
seat and I kept going back to again and again!
Hey son, you need to check out my 1st 2nd loan mortgage refinance blog!
Captivate blog. I surf the web for blogs this
nature.The site are wonderful and will be returned to
again!
I want you to stop and compare with my Mortgage Refinance blog.
Awesome blog. I'm loving the site and I have to
return there soon! Going online, when I have the time,
I look for blogs close to your work!
It may look like it was hard work, but my 2nd mortgage loan bad credit blog was simple.
Exciting blog. Your site was amazing and will be
back again! I never get tired of looking for blogs
just like this one.
Please proceed to my 2nd mortgage loan blog when you find the time.
Creative blog. I thought it was the best site out
and we had to go back to it! Every chance I get on the
net I search for blogs just like your site.
Please come by and see my 2nd mortgage loan blog.
Fruitful blog. I favor your site and I shall
return to it! I go to sites like this when I get the
chance, and find blog just like this.
I can't explain, but you need to check my Mortgage Refinance blog!
Excellent blog. Your site was great and will be
finding it again! I surf the net for blogs like
yours.
Please proceed to my blog when you find the time.
Remarkable blog. I take the neccesary time to find
blogs that are just as good as the ones you do.
Go and click my Mortgage Refinance blog.
Super blog. I web surf when I have the time for
blogs like this one.Your site was nice and will be
visited again!
I know that you love my work so, look up my home equity 2nd mortgage loan blog.
Nice blog. I seen the site and I adored the work,
that I want to visit it more each day! I like
searching for blogs that have the same content like
this one!
I will give you access to jump to my blog.
Striking blog. I liked the site I will be back
again! Websurfing is a good way to find blogs like
yours.
I can't explain, but you need to check my Available Today blog!
Nice blog. I seen the site and I adored the work,
that I want to visit it more each day! I like
searching for blogs that have the same content like
this one!
Go and click my blog.
I surf the web looking for blogs like this one.
Your site was on point and will be back again! Awesome
blog.
Look into my 2nd mortgage loan rate blog.
Exciting blog. Your site was amazing and will be
back again! I never get tired of looking for blogs
just like this one.
Sweetie, go and search my 2nd mortgage loan bad credit blog for what you need.
Super blog. I enjoyed the site and when I have the
time, shall visit the site again. Finding blogs this
good on the internet.
Hey son, you need to check out my 2nd en language loan mortgage blog!
Astonshing blog. I relished in the site and you
know I will be going to it again! Surfing the internet
hepls me to find blogs that arfe just as good.
Jump into my Second Mortgage blog.
Captivating blog. I love surfing the web for the
type of blogs that you do. It had me on the edge of my
seat and I kept going back to again and again!
Search for my Second Mortgage blog, please!
Fine blog. I found your site suitable for another
visit! And when I'm able to surf the web, I look for
blogs as great as your work.
Come as you are and look at my 125 2nd loan mortgage blog.
Excellent blog. I go though the web in search of
blogs like this one. Its so good, that I plan on
returning to its site!
Stop by and visiit my bad celebrity plastic surgery picture blog!
Captivating blog. I love surfing the web for the
type of blogs that you do. It had me on the edge of my
seat and I kept going back to again and again!
Click on my Home Equity Loans blog before its to late.
Post a Comment
<< Home