Oracle

List Of SQL(Oracle) Syntax

Data Definition Language (DDL) 1. Create Table Syntax Create table emp(empno number(3), empname varchar2(50)); 2. Alter table Alter table emp […]

Share

Basic oracle queries Part -2

Part1 – Continue 81) Display the jobs found in department 10 and 20 Eliminate duplicate jobs. SQL>select distinct(job) from emp […]

Share

Basic oracle queries Part -1

SQL QUERIES 1) Display the details of all employees SQL>Select * from emp; 2) Display the depart information from department […]

Share

Architecture of Oracle Database Management System

Oracle is a Relational Database Management System (RDBMS), which uses Relational Data Model to store its database and SQL (commonly […]

Share

Download Free Oracle 10G Express Edition For Windows (MF)

Download Free Oracle 10G For Windows.. How To use? After Installation Go to Programs – Accessories -> Oracle 10g Express Edition -> […]

Share

List Of Oracle Time/Date Function

Oracle provides a data type date that behaves like a timestamp. It stores a date and a time. Internally a […]

Share