If you’ve ever encountered the ‘Cannot resolve the collation conflict’ error message while working in SQL Server Management Studio (SSMS), you know how frustrating it can be. Collation issues within SSMS can arise when the collation settings of the SQL Server instance and databases are misconfigured or mismatched. In this…

ASCII is an abbreviation for American Standard Code for Information Interchange, and to make things a bit more clear it is a character encoding standard for electronic communication. It was invented as a 7-bit character set (128 bytes), but as it became common to use 8-bit bytes to store each…

A batch file is a script file which contains series of commands that get executed one after the other, in a sequence. A batch file is created in a simple plain text file (Notepad or WordPad) with .bat extension and is executed by the command-line interpreter (cmd.exe …

To prevent unauthorized access to the REST services, Oracle Apex is providing a few various security methods. One of the easiest methods to implement is First-Party Authentication also known as “Basic authentication” which will be covered in this article. In order to protect the REST services, a role, privilege, and…

While creating complex applications within Oracle Application Express (APEX)it might happen that an Oracle Database needs to be exposed to the RESTful Web, or the application itself might have to interact with other databases by creating client-side API requests. …