CREATING TABLE WITH SUB-QUERIES With this method, table is created automatically with the column types that result from a query. While the table is created, data that came from the …
Read More »ismail tolga can
Oracle SQL Tutorials Chapter 7 ( Part 1 of 2 )
Chapter 7 – CREATING AND MANAGING TABLES Classify Main Database Objects Examining Table Structure Data Types of the Columns Creating a Simple Table Understanding How Schema Objects Work DATABASE OBJECTS …
Read More »Oracle SQL Tutorials
Hi, I’m writing Oracle SQL articles and sharing with you. You can learn SQL by following my articles and trying example SQL’s. Here are the SQL Tutorials, I highly recommend …
Read More »Oracle SQL Tutorials – Chapter 6 (Part 2 of 2)
DATABASE TRANSACTIONS DB transaction is start with any of them; When DML command is running. When DDL command is running. When DCL command is running. Transaction is started when a …
Read More »Oracle SQL Tutorials – Chapter 6 (Part 1 of 2)
Chapter 6 – DML (Data Manipulation Language) You can add, delete or update data, using the Data Manipulation Language. INSERT : Adding data to a table. UPDATE : Changing data …
Read More »Oracle SQL Tutorials – Chapter 5
Chapter 5 – Selecting Data From Multiple Tables Usage of multiple tables in one query Combining tables – JOIN Different Types of SQL Join Left Outer Join Right Outer Join …
Read More »EPPM : This Account Has Been Locked Error
Hi , if you have this error when you’re attempting to login with ‘admin’ user; You must apply below steps to unlock the ‘admin’ user. The user can be locked …
Read More »Oracle SQL Tutorials – Chapter 4
Chapter 4 – Group Functions AVG Function SUM Function MIN Function MAX Function COUNT Function DISTINCT Function GROUP BY Statement HAVING Statement One row functions can be applied to …
Read More »Oracle SQL Tutorials – Chapter 3 (Part 3 of 3)
CONVERSION FUNCTIONS TO_CHAR (DATE) TO_CHAR(date, ‘format’) It’s case-sensitive and must be written between quotes. It must contain a valid date format. Let’s list the hire dates of employees like below. …
Read More »Oracle SQL Tutorials – Chapter 3 (Part 2 of 3)
NUMERIC FUNCTIONS ROUND Let’s try some different usages of the ROUND function. SELECT ROUND (45.923), ROUND (45.943, 1), ROUND (45.924, 2), ROUND (44.923, -1), ROUND (55.923, -2) FROM DUAL; …
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial