About Linux Operating system 1. It was originally developed by Linus Torvalds. It name is mixture of Linus and Unix2.Linux Operating system is modular in design. We have user space and Kernel3. Kernel interacts with Hardware and schedule and use resource like CPU, Memory, storage and network on behalf of application. 4. Application runs in […]
Primary Key in Oracle with Examples
Introduction to Primary Key A primary key is the column or set of column in the table which uniquely identifies a row in the table. Properties of Primary key You cannot have duplicate values in it. i.e it should be unique in the table It can not be null or contain empty strings It should […]
how to create table in oracle
This article talks how to create table in Oracle,primary key ,Foreign keys,create table syntax in oracle with Examples. This will be very useful for Oracle DBA’ s and Developer both.They play with it many times in the day and an good knowledge can definitely help them expedite the task.They often get confused the datatype and […]
How to Install Oracle Express Edition for SQL Practice
We have to practice the sql statement to become well versed with syntax, restrictions and expression. Oracle Express Edition for windows is a good environment to do practice on your laptop or Desktop . I am going to provide you the step by step installation guide for that. Step by Step Oracle Express Edition Installation […]
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-00054: resource busy and acquire with NOWAIT specified is a common error seen in Oracle Database Reference: Oracle documentation This generally happens when you try to execute a DDL on the table which is locked by transaction .It also happens if select for update statement is executed with NOWAIT option Example SQL> alter table emp add […]
Practice Oracle Cloud Infrastructure 1Z0 932 questions
Oracle Cloud Infrastructure is heavily being used in the Industry.It is a IaaS/PaaS Offering of Oracle corporation Having a certification on Oracle cloud infrastructure add lot of value to your Resume. Oracle Cloud Infrastructure Certification Examination checks your knowledge on Virtual Cloud Network, File storage , Compute Machine, Oracle database as a service, Identity Access […]