Quoting Mechanism for String Literals

This entry is part 11 of 13 in the series New Pl/Sql features 10g

We’ve all come to a point where the number of apostrophes in string literal were so plentiful you couldn’t see the forest from the trees. Oracle introduces a nifty little solution in the form of Q. (famous from the Bond movies :))
Looks familiar?

No more! Use q to specify your own quoting delimiter

Look again! Much nicer isn’t it?

Series Navigation<< Change to the BINARY_INTEGER DatatypeCompile-time warnings >>

Posted in Pl/Sql Tagged with: , ,

Leave a Reply