ORA-00904 : invalid identifier is one of the common error seen. You might get creating tables, selecting from tables and many more. It most happens because of the syntax issue. We have to be very careful with the syntax. The key is to remember syntax and write the code correctly. You might want to check […]
Supplemental Logging in Oracle
What is Supplemental Logging in Oracle Oracle Redo log file has the record of all the operation performed in the database by default or automatically.So Redo log files are generally used for instance recovery and media recovery. They are also used for Physical standby or physical replication. But by default Oracle redo logs files does […]
Query to find object dependencies in oracle
Object dependency is important to understand in Oracle. It basically tells the parent child relationship between the objects. Lets understand with an example. We create one table CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL, created_at date ); Right now this table is alone and it is not […]
JSON in Oracle database
Lets first start with what is JSON What is JSON JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition – December 1999. […]
How to change date format in oracle database
We often need to change the date format while checking. Here are some ways which you can use to change date format in Oracle database Oracle Default Date Format The default date format in oracle is controlled by the value of the NLS_DATE_FORMAT parameter. The following query can be used to find the current value […]
Practice Oracle Cloud Infrastructure Foundations 2020 Associate 1Z0 1085 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 Foundations 2020 Examinations checks your knowledge on Virtual Cloud Network, File storage , Compute Machine, Oracle database as a service, Identity […]
