Insert with order by in forms [message #683457] |
Tue, 19 January 2021 14:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/51284ef89d03d81360279635761fcedd?s=64&d=mm&r=g) |
compuscience
Messages: 97 Registered: September 2012
|
Member |
|
|
I create oracle form
And need to insert values as select
But need to use this select with order by
But forms didn't run with it
Complication error
But without it the code ran but data not ordered
How can i do that
insert into table (column1,2)
select column3,coulmn4
from table
order by column3
|
|
|
|
|
Re: Insert with order by in forms [message #683460 is a reply to message #683459] |
Tue, 19 January 2021 14:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
And why do you never follow the rules giving your versions (Forms and Oracle rdbms) and formatting your posts?
Michel Cadot wrote on Wed, 11 November 2020 12:10
He took you 9 hours to answer the simple question about your version, wait a little bit .
In the meantime, review your previous topics, answer the question we posted and feed back in the other ones.
[Updated on: Tue, 19 January 2021 14:55] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
Re: Insert with order by in forms [message #683494 is a reply to message #683457] |
Sun, 24 January 2021 13:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Dear Sir,
Do you need to insert multiple record at ones and you also need to insert it on sequence its that your question?
are you using Developer 6I ?
if yes then used upload system in oracle form with excel and in excel you sort your record what ever type you want. And if you want to know how to upload record with excel in developer 6I then reply i will send you sample fmb form to upload your record with excel
another way is to create a column in you table like serial no and insert serial number.
Hope you find your answer
Regards
Shahzaib
|
|
|