Search

Oracle Learning

Introduction to Oracle

Introduction to Oracle

The language developed by IBM to manipulate the data stored within Codd's model was originally called Structured English Query Language (SEQUEL) with the word English later being dropped in favor Structured Query Language (SQL).

SQL is a language that provides an interface to relational database systems. Structured Query Language or SQL is a standard Database language which is used to create, maintain and retrieve the relational database. It is particularly used to work with structured data where there is relations associated within the data itself.

SQL encompasses DML (Data Manipulation Language), for INSERTs, UPDATEs, DELETEs and DDL (Data Definition Language), used for creating and modifying tables and other database structures.

Articles on SQL

Python cx_Oracle

Oracle Database Connection in Python

0

Python if , elif and else

Python Conditions and If statements

0

Sed Command

Linux/Unix Sed Command

0

Linux 'Touch' Command

Basic Touch Command Examples in Linux

0

Learning C

C Language Introduction

0

Download And Install Python

How to download and Install Python on Windows 10

0

Python for beginners

Learning Python Part 1

3

Use of Unix find command

Use the Unix find command to search for files

1

Oracle 12C R2

Things Developers Will Love About Oracle12CR2

0

Struct Alignment and Padding

Struct Alignment and Padding in C++ And C

0

C++ OOPs Concepts

OOPs (Object Oriented Programming System)

0

Friend function

Friend function C++

0

The diamond problem Solution C++

Solving the Diamond Problem with Virtual Inheritance

0

Multiple Inheritance in C++

Multiple Inheritance in C++ and the Diamond Problem

0

Pointers

C++ Pointers

0

Structures

C++ Structures

0

argc and argv in C++

Command line arguments in C++ using argc and argv

0

Types of Inheritance in C++

Inheritance and access specifiers C++

0

Java date pattern

Java Date Pattern Syntax

0

Java Date and Calendar

Java Date formats

0

Interface and Abstract

Interface and Abstract Class After Java 8

0

Iterate Array in Java

Use of for loops to iterate Array in Java

0

scanf() and gets() in C

When and Where to use scanf() and gets() in C

0

Linux ls Command

Basic ls Command Examples in Linux

0

JAVA, C and C++

Difference between Java, C and C++

0

JAVA Data Type

Data types in Java

0

C Facts

Some Facts About C

0

Java unreachable code

Unreachable Code Error in Java

0

INTERVIEW EXPERIENCES

Interview Experience

Google 9+ Years experience Customer Solution Engineer

Interview Experience

UBS interview Questions ( PLSQL 6 Years Experience)

Interview Experience

LNT Infotech-Python Developer Interview Questions Experienced

Interview Experience

Mindfire Solutions Python developer Interview Questions Experienced

Interview Experience

Onit India Pvt Ltd - Python Developer Interview questions Experienced

Interview Experience

Incedo Interview questions Experienced Python Djnago

Interview Experience

Python Developer - Kapstone LLC Pune Location - Experienced Interview Questions

Interview Experience

NICE Interactive Solutions Interview Questions Experienced PL/SQL

Interview Experience

Persistent Interview Experience C++

Interview Experience

Attra Interview Experience (PL/SQL 7 Years Experience)

TypeScript Programmning Language

New HTML5 API

New HTML5 APIs

HTML Arrow -> Range: Decimal 8592-8703. Hex 2190-21FF.

HTML CSS

How To Override One CSS Class With Another

JSP templates

Use JSP templates to encapsulate Webpage layout

Articles

09

FEB

Pow(x, n)

08

FEB

Binary Tree Inorder Traversal

08

FEB

String to Integer (atoi)

07

FEB

Minimum Height Trees

03

FEB

Subtree of Another Tree

02

FEB

Reverse Linked List

02

FEB

Invert Binary Tree

31

JAN

Rotate Image

31

JAN

Spiral Matrix

31

JAN

Set Matrix Zeroes

30

JAN

Delete the Middle Node of a Linked List

30

JAN

6 Algorithms Every Developer Should Know

29

JAN

Remove Nth Node From End of List

18

JAN

Longest Palindromic Subsequence

14

DEC

Generator vs. iterator in Python

09

NOV

Different ways to get maximum salary using Oracle SQL

28

SEP

Python List Comprehensions

27

SEP

Python Iterable and Iterator

27

SEP

The xargs command in UNIX

27

SEP

Find and Delete Files Older Than X Days In Linux

26

SEP

Python - Reduce Function

26

SEP

Python Global Interpreter Lock

25

SEP

Clustered and Non-clustered indexes

22

SEP

JavaScript - Date

20

SEP

Python unpacking operator : * and **

20

SEP

Python zip() Function

20

SEP

Python - Find Max value in Dictionary

20

SEP

Python Multiple Inheritance

13

SEP

Python Inheritance

13

SEP

Class method and Static method in Python

06

SEP

Python new Walrus operator := in 3.8

05

SEP

CoAction Python Developer Experienced

05

SEP

Difference between re.match(), re.search() and re.findall()

03

SEP

eval in Python

01

SEP

8 Reasons Coding for Kids is Not Just Another Fad

01

SEP

Python Overloading

18

JUL

Hackerrank - Cavity Map Problem

14

JUL

hackerrank Cut the sticks problem

12

JUL

Sort list of dictionaries by values in Python

08

JUL

Hacker-rank Sock Merchant

18

JUN

Rename Git Local and Remote Branches

09

JUN

Copy, Cut and Paste in Vim / Vi

12

MAY

Array in Python

08

MAY

Python Generator Expressions

30

APR

Regular Expression Dot (.)

29

APR

Advantages and disadvantages of Package

27

APR

Python - Random Module

27

APR

Python chr function

26

APR

Python enumerate function

26

APR

Webscrapping of weather data

26

APR

Named Groups and Backreferences

26

APR

Pandas Series.str.extract()

23

APR

Webscrapping in Python

22

APR

What is the purpose of "end” in Python

22

APR

Docstring in Python

21

APR

Built-in data types available in Python

21

APR

Operators in Python

21

APR

Pickling and Unpickling in Python

21

APR

Difference between range & xrange

21

APR

What is self in Python

21

APR

Break , continue and pass keywords in python

19

APR

Difference between tuple and list

19

APR

Python's parameter-passing mechanism

19

APR

Python deepcopy

19

APR

Python shallow copy

19

APR

Exceptions in Python

18

APR

How to ignore changes for some files in git

18

APR

How to find common elements in two lists in Python ?

18

APR

Mysql DML with Python3

18

APR

Difference between attr, prop and val

18

APR

Ternary (Conditional) operator in Javascript

17

APR

Python Anonymous/Lambda Function

16

APR

The difference between Python 2 and Python 3

27

MAR

Using the SQL Communications Area (SQLCA)

15

DEC

Case Insensitive comparison in Python

26

NOV

JavaScript Functions

25

NOV

Writing Your First JavaScript Program

18

NOV

PL/SQL Cursor

26

OCT

Oracle NOT EXISTS operator

21

OCT

What is TypeScript

21

OCT

Oracle DBMS_OUTPUT package

20

OCT

Unix who command

13

OCT

Star, SnowFlake and Galaxy Schema

13

OCT

Data Warehousing : Dimension and Fact Tables

12

OCT

ETL - Introduction

10

OCT

JavaScript : An introduction

06

OCT

PL/SQL MAP Member Functions

29

SEP

Hierarchical Queries

28

SEP

Difference between WHERE and HAVING clauses

06

JUN

Bitmap Indices, Advantages and Disadvantages

04

JUN

What is Index in Oracle

03

JUN

Normalization in DBMS: 1NF, 2NF, 3NF ,BCNF, 4NF and 5NF in Database

02

JUN

delete operator and free() function in C++

31

MAY

When the NOCOPY Hint is Ignored PL/SQL

31

MAY

Collections Associative array, Nested table and Varray

29

MAY

PL/SQL : uses of database trigger

28

MAY

Oracle / PLSQL: REGEXP_COUNT Function

16

MAY

Oracle PLSQL Exceptions

16

MAY

Difference between Oracle Truncate and Delete

16

MAY

Oracle PL/SQL INSTEAD OF trigger

04

MAY

Oracle / PLSQL : create, drop, disable, and enable a primary key

22

APR

What happens after Commit and Rollback in Oracle

19

APR

Oracle Database 11g Architecture

15

APR

Linux commands you should never run on your system

04

APR

Javascript/Jquery onload event

27

MAR

Decode Function in Oracle

10

MAR

Oracle Autonomous Transaction

10

MAR

Oracle RETURNING INTO Clause

10

MAR

Oracle Anti-Joins and Semi-Joins

10

MAR

Which is better IN or Exists in Oracle

10

MAR

Oracle PL/SQL DML Error Logging using DBMS_ERRLOG Package

09

MAR

UNIX/LINUX grep command

05

MAR

Oracle PL/SQL Mutating Triggers

05

MAR

Triggers and their different functionalities

18

FEB

Oracle Global Temporary Tables

18

FEB

Private Temporary Tables in Oracle Database 18c

17

FEB

Oracle Optimizer Hints

17

FEB

Oracle PL/SQL WHERE CURRENT OF & FOR UPDATE

17

FEB

Oracle PL-SQL : REF CURSOR

17

FEB

Oracle /PL-SQL: How to return a Table from a function

16

FEB

Oracle / PLSQL:DROP TABLE Statement

13

FEB

All Oracle NULL related Functions

10

FEB

Different types of Joins in Oracle

01

FEB

Different ways of deleting duplicate rows in Oracle SQL

29

JAN

Oracle ANYDATA Type Usage in SQL,PL/SQL and Complex Types

29

JAN

Database PL/SQL Packages and ANYDATA Types

28

JAN

JDBC - Statements, PreparedStatement and CallableStatement

18

JAN

Paste Command in Unix / Linux

17

JAN

Oracle 12C Top-N Feature

16

JAN

Overloading with same family data types

16

JAN

Smarter than PL/SQL Compiler? Test Yourself - PLW-5005

15

JAN

Great new SQL and PL/SQL features in 11g

06

JAN

Oracle 12C with clause with PL/SQL

02

JAN

Multiple indexes and VARCHAR2 length in Oracle 12C

02

JAN

Column Can be defined as Invisible

02

JAN

Sequence can be used as Default value

31

DEC

Basic vi Commands

31

DEC

Playing with case of characters in vi

30

DEC

All about Oracle Analytic functions

16

DEC

Passing parameters in the <jsp:include> tag

↟