Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

procedure for inserting rows

teefu ghulamAug 23 2010 — edited Aug 26 2010
dear members,

i have a table with some missing numbers in a col1.
how can i add rows containing missing numbers.
starting and ending number is given in the procedure.
let us say starting from 1 to 10.

table
id col1
1 2
2 3
3 4
4 9


Required Result after running the procedure.

table
id col1

1 2
2 3
3 4
4 9
5 1
6 5
7 6
8 7
9 8
10 10


can i have that procedure.



regards


teefu.

Edited by: user_teefu on Aug 23, 2010 2:19 PM
This post has been answered by 780914 on Aug 23 2010
Jump to Answer

Comments

Christian Erlinger
That would entirely depend on

1.) Your Forms Application
2.) What features of Sharepoint you'd use
3.) What you want to integrate of your forms application and sharepoint

which are basically things we do not know. The only thing which comes to my mind would be LDAP, which would allow both forms and sharepoint to have the same login for each user. For everything else your question is way too general.

cheers
Andreas Weiden
If the question is "How can we use Sharepoint instead of Forms?", i would say, you hardly can.

Sharepoint is more or less a collaboration tool, Forms is an application-building tool.

Just my 2 cent.
lake
I don't think getting forms to interact with sharepoint sounds very easy. Forms only talks to oracle and I believe sharepoint only talks to sqlserver. So the only way the two could interact possibly could be with a link between oracle and sqlserver. Which would be?
transparent gateway for sqlserver?

I believe sharepoint can also create some data entry forms. don't know how easily it does them.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 23 2010
Added on Aug 23 2010
13 comments
5,534 views