What is the difference between Voyage Prepackaged Access Reports SQL and sqlplus (SQL*Plus) on the server?
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Question
What is the difference between Access SQL in Prepackaged Reports and sqlplus on the Voyager server?
Answer
The Voyager server uses SQL*Plus, which is different from Access SQL, and Access SQL is a subset of what is available in SQL*Plus. It is not too difficult to translate from one to the other, but they are not compatible (that is, you can't necessarily run one platform's SQL code on the other platform).
Examples
Access SQL:
SELECT
LAST_NAME
FROM
PATRON
INNER JOIN
PATRON_GROUP
ON PATRON.PATRON_GROUP_ID =
PATRON_GROUP.PATRON_GROUP_ID
WHERE PATRON_GROUP_CODE Like “fac*”
AND CREATE_DATE > #1/1/2001#
AND HISTORICAL_CHARGES > “0”;
SQL*Plus:
SELECT
LAST_NAME
FROM
PATRON,
PATRON_GROUP
WHERE PATRON.PATRON_GROUP_ID =
PATRON_GROUP.PATRON_GROUP_ID
AND PATRON_GROUP_CODE Like ‘fac%’
AND CREATE_DATE > TO_DATE(‘1/1/2001','mm/dd/yyyy')
AND HISTORICAL_CHARGES > 0;
Additional Information
See also: Using the SQL query pass-through option in Voyager PrePackaged Access Reports
- Article last edited: 30-Jan-2022