Listing Objects in Oracle
If you want to list tables in MySQL, you simply type the following command: Oracle does not provide such a short cut. You have to type the following command: The…
Adding a leading dollar sign ($) in front of a number in Oracle
presenting numerical data with a leading dollar sign adds a touch of clarity and professionalism to reports and queries. Whether you’re a seasoned database administrator or a budding SQL enthusiast,…