Oracle string quote escape tool : There will be a times when you are writing dynamic sql and that sql has lot of quote constants in where clause or in your select list , escaping these quotes can be quite cumbersome if you don't have the right tool.
If you have a large query or string which has quotes in it and you do not want to bother checking the escapes and want to use the escaped query / string readily in your plsql.
Below tool will help you generate escaped string from Oracle plsql standpoint , just copy and paste it in your code
Subscribe to:
Post Comments (Atom)
-
If we want to perform hierarchical queries we need to use connect by clause in our sql query. Hierarchical query is any query wherin yo... -
This is a Beginner level article but can be referred readily by guys using Oracle Database moderately for a refernence. You can identify t... -
If you have 3000 lines of code and a custom exception handler like when others. The ORA 06502 can be notoriously elusive to find. This er...
No comments:
Post a Comment
Please leave your relevant comments and questions only.