[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Use with-clause in begin-select Statement
- Subject: [sqr-users] Use with-clause in begin-select Statement
- From: "Hug Marcel (KSFH 344)" <marcel.hug@credit-suisse.com>
- Date: Mon, 31 Mar 2008 16:56:09 +0200
- Delivery-date: Mon, 31 Mar 2008 10:59:41 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AciTP1rigvEmV+C2TpmaqwROV8MW6w==
- Thread-topic: Use with-clause in begin-select Statement
Hi,
we want to use the WITH Oracle statement to make reuse of sql definitions. E.g.:
begin-select
WITH
MY_SQL_DEF1 AS (Select
<any_columns> From <table>
),
MY_SQL_DEF2 AS (Select
<any_columns>
FROM
MY_SQL_DEF1
)
end-select
and then:
begin-select
SELECT
<any_columns>
FROM
MY_SQL_DEF2
end-select
How is this possible? Or do we have a begin-sql statement?
Thx - Marcel
Marcel Hug
Credit Suisse
Information Technology
Solution Engineering, KSFH 344
Oracle | Hyperion Lead Ing. FN Reports
Zollstrasse 20/36
CH-8005 Zürich
Tel: +41 1 334 74 20
mailto:marcel.hug@credit-suisse.com
http://www.credit-suisse.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users