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 […]
Kill session in Oracle
Alter system kill session command alter system kill session is a very important command for Oracle DBA. We can kill oracle session in the oracle database with the help of it. So this is useful for people looking for the answer of the question How do you kill a session in Oracle? Syntax alter system […]