sql - Bringing the other column , along all with all the other columns of the table (Oracle) -


i trying bringing other column , along all other columns of table (oracle)

as shown below

select order_id,person_id,col4,col5,* orders 

it giving below error :

ora-00936: missing expression 00936. 00000 -  "missing expression" *cause:     *action: error @ line: 1 column: 66 

any inputs helpful !!

use alias:

select col1, col2, c.* my_table c 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -