<div>
What you want to do in the virtual field?<br />
<br />
it can be like this<br />
SELECT field1,field2,field3, 5+3 as 'Sumof5n3' FROM myTable<br />

</div>


<div>
it doesn't work. Oracle 8... I want to just write it.<br />

</div>


<div>
Use &quot;&nbsp;instead of ' - that is ANSI standard. Anyway, you can omit the quotes or ticks if the name does not contain spaces, dots, hyphens or alike.<br />
<br />
select 1 as &quot;One&quot; from dual;<br />
select 1 as One from dual;<br />
select 1 One from dual;<br />
<br />
are all the same<br />

</div>


<div>
u need to use double quotes instead of single quotes
</div>


<div>
What i understood from your question is as under.<br />
<br />
SELECT field1,field2,field3, 'myfield' as 'Samplefield' FROM myTable<br />

</div>


<div>
any sample doesn't work.<br />
my system is Oracle 8
</div>


<div>
Try this.<br />
<br />
SELECT field1,field2,field3, 'MYFIELD' AS &nbsp;Samplefield FROM TABLE;
</div>


<div>
Argh, sorry for the botched formatting there, but hopefully you get the idea.<br />
<br />
-Mark<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi to all experts,<br />
I want to create a select with a virtual field with a value.<br />
For example my tabla has 3 field field1,field2,field3<br />
but i want to take a custom field and it's not in table.<br />
<br />
SELECT field1,field2,field3, myfield as 'Samplefield' FROM myTable<br />
This sql work with sql server.How can i convert it to oracle 8.<br />
<br />
Thanks
</div>
</div>


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.

Thanks

Oracle Select-As Statement

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.