Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle sql problem

Status
Not open for further replies.
sdsfdsdf

sdsfdsdf

Technical User
Aug 16, 2000
1
0
0
US
i am doing
insert into table_name select * from table2 order by
table2.col1

this order by i am getting error
 
Sort by date Sort by votes
In this case, the usuage of order Clause and Group by clause will definitely give error. Remove order by clause from insertion statement.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
176
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
74
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
94
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
1K
carp
carp
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
74
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top