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
QueryLight is a lightweight Oracle database client.
Please help us in betterment of the software by donating generously. Your encouragement and funds will keep the site going.
Donate Here on Paypal.
Subscribe to:
Posts (Atom)
AWS solution architect exam questions.
Before taking this let it be known that the questions are sourced from random sites using simple algorithms. The authenticity of questions a...
-
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...
-
In this tutorial video we have demonstrated how to use oracle analytical functions like lag , lead , sum and avg etc. Example 1. Use of...
-
Starting from Oracle database release 10g you can have DML's succeed with partial data failures. How ? Default reaction of any bulk I...
No comments:
Post a Comment
Please leave your relevant comments and questions only.