CODEWITHSUNDEEP
sqloracle-database
Fei-Xue
Fei-Xue

Reputation: 86

PL/SQL to select all and more columns

In SQL Server the following gives me column 50 followed by all the columns. How do you achieve the same with PL/SQL?

select col50, * from mytable

Thanks.

Upvotes: 0

Views: 4823

Answers (1)

Justin Cave
Justin Cave

Reputation: 231661

You just need to qualify the *.

SELECT col50, mytable.*
  FROM mytable

or

SELECT col50, t.*
  FROM mytable t

Upvotes: 3

Related Questions