ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Query Oracle syntax (https://www.excelbanter.com/excel-discussion-misc-queries/142468-ms-query-oracle-syntax.html)

Jeff[_3_]

MS Query Oracle syntax
 
Does anyone know syntax for renaming a field using MS Query with a
oracle databse?

select f1 "MyField" from mytable; returns an error


actually more correctly stated my query is something like
select myfunction(f1, f2, f3) "MyName" from table1 where f1 = 1;


Thanks for pointing me in the right direction.



All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com