Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Data Model with Calculations

edited Jan 25, 2017 4:00AM in Design Tools & Output Technologies - JDE1 (MOSC) 11 commentsAnswered

Hi,

I am creating a data model using standard SQL query where I want to have a calculated column.  My select statement is as follows:

SELECT

     "Table"."Field1" as "Field1,

     "Table"."Field2" as "Field2,

     "Table"."Field1" - "Table"."Field2" *.3 AS "Field3"
FROM "Table";

I keep getting an error message not able to load SQL.  Can you advise how I can go about resolving this and getting the result I need?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center