Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using a Cursor to Retrieve Data From One Table and Insert Into Another table

 
seema chhetri
Ranch Hand
Posts: 43
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Using a Cursor to Retrieve Data From One Table and Insert Into Another

i tried the below code but it couldnt helped...





thanks
 
fred rosenberger
lowercase baba
Bartender
Pie
Posts: 12020
25
Chrome Java Linux
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nope. We don't hand out answers here. Folk will help YOU write it, but you need to Show Some Effort yourself.

Or, you can always make a post in "Jobs offered" and see if anyone will code it for a fee.
 
chris webster
Bartender
Pie
Posts: 2359
31
Linux Oracle Postgres Database Python Scala
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As Fred says, you should ShowSomeEffort.

However, here is a tip: Use "INSERT...SELECT" to perform the SELECT and the INSERT in a single statement e.g.
You should be able to figure it out from here.

[Edited my reply after I spotted the fairly obvious fact that you are using Oracle PL/SQL - doh!]
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic