Find out how to provide read only access, on tables in multiple schemas, to a user in Oracle database. SQL examples provided along with detailed description.
SQL and CNC Being a CNC i.e. JD Edwards System Architect, as we would like to call, it is our responsibility to have knowledge about database management system and expertise/experience with SQL databases such as Oracle, SQL Server and DB2/400 with regards to EnterpriseOne. We will be required to cater to various SQL execution requests ranging […]
What is SQL? SQL (pronounced as Sequel or some prefer es-que-el) stands for Structured Query Language. Let us focus on the three words that form the full form of SQL and see their definitions : Structured : construct or arrange according to a plan; give a pattern or organization to. Query : a question or […]
I remember when I started learning SQL, I was given examples of employee databases, food inventory, cities etc. They all had one thing in common, all of them had nothing to do with my real life. So I have created this unique example of Friends table. So this can be implemented by everyone and it is […]
Considering the importance of databases in computer applications and the rising demand for database administrators, a lot of people are trying their hands at getting started with Oracle. If you are one of them and do not know where to begin, then you need not worry as you have come to the right place. Getting […]