[
http://jira.codehaus.org/browse/MSQL-52?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=212066#action_212066
]
Jon Strayer commented on MSQL-52:
---------------------------------
DROP SEQUENCE &&schema..ACCOUNT_CODE_DEFINITION_SEQ;
would become
DROP SEQUENCE SOME_SCHEMA.ACCOUNT_CODE_DEFINITION_SEQ;
SELECT &1 FROM DUAL;
In this case the &1 refers to the first command line argument.
The Oracle doco is
here:http://www.oracle.com/technology/support/tech/sql_plus/htdocs/sub_var9.html
It looks like for our uses '&' and '&&' are equivalent. And any '..' would be
converted to a '.'. But a single '.' is just concat.
> Add Oracle SQLPlus syntax for substitution variables
> ----------------------------------------------------
>
> Key: MSQL-52
> URL: http://jira.codehaus.org/browse/MSQL-52
> Project: Maven 2.x SQL Plugin
> Issue Type: New Feature
> Affects Versions: 1.4
> Reporter: Jon Strayer
>
> Replacement variables in Oracle SQLPlus files have the format of
> "%%whatever." This makes them rather hard to use with the Maven SQLPlugin.
> If this syntax were added as an option then the SQLPlugin could execute more
> scripts.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
