Avatar of erenpasa

asked on 

Oracle Select-As Statement

Hi to all experts,
I want to create a select with a virtual field with a value.
For example my tabla has 3 field field1,field2,field3
but i want to take a custom field and it's not in table.

SELECT field1,field2,field3, myfield as 'Samplefield' FROM myTable
This sql work with sql server.How can i convert it to oracle 8.

Oracle Database

Avatar of undefined
Last Comment

8/22/2022 - Mon