2019-01-18 20:45

Please follow the below :1- Go to https://bit.ly/2sxOWyO2-Provide the required code Read More

SEQUENCES

2011-10-18 19:08

SEQUENCESYou create a sequence to generate a unique numbers.Create sequencesYou can create a sequence by using CREATE SEQUENCE statementFor exampleCreate sequence for the EMPNO column of the… Read More

Transaction Control

2011-10-17 15:55

To complete your DML statements you need to control in it by1- CMMIT: make all pending changes in a transaction permanent.2- ROLLB… Read More

DML

2011-10-16 13:02

Manipulating Data Language (DML)Before execute DML statements, you must have INSERT,UPDATE, and DELETE privilege. INSERT EXAMPLES1- INSERT INTO NEWEMP(EMPNO,ENAME,DEPT… Read More

Create And Alter Tables

2011-10-14 15:46

Before create a tables please follow the below rules not for table only but for all database objects.1- All names begin with letters and contain no more than 30 chara… Read More

Constraints

2011-10-13 18:28

Oracle uses constraints to prevent invalid data entry into a table.You can add and remove constraint after creating a table.Constraints ensure that data in a table adhere to the recognized b… Read More

Common Database Structure

2011-10-12 18:11

Common Database structure1- Table: Common structure in database is a table .table consist of columns and rows in which data is stored .the intersection of a column and a row is ca… Read More

Common Date Functions

2011-10-03 19:44

DATE FUNCTION IN SQL1- MONTHS_BETWEEN Function : finds the number of months between two datesFor example assume that you want find number of months between an employee hire date And sy… Read More

DATE Arithmetic

2011-10-03 19:31

By using arithmetic operators you can perform calculations on dates.For exampleSELECT EMPNO,ENAME,SAL,HIREDATE,HIREDATE+100 “NEW DATE”FROM EMP; EMPNO ENAME … Read More

SYSDATE Function

2011-10-03 19:27

Is a date function returns the current date The default format is DD-MON-YYIf you want to select current date Type Select sysdate From dual;SYSDATE---------03-OCT-11… Read More

Case Conversion Functions

2011-10-02 19:34

Case conversion function used to display character values in a different case,without changing the case of the data in the tableTypes of case conversion function 1- UPPER: that di… Read More

SQL Functions

2011-10-02 19:25

Single row function accepts one or more arguments and returns one value for each row.A single row functions can be used in SELECT, WHERE, and ORDER BYAlso single functions can be nestedTypes… Read More

SORTING BY MULTIPLE COLUMNS

2011-10-02 19:23

You can used more than one column to sort data by identify multiple columns in the ORDER BY clause.FOR EXAMPLE SELECT EMPNO,ENAME,JOB,DEPTNOFROM EMPORDER BY DEPTNO,JOB; EMPNO ENA… Read More

Sorting By Column Alias

2011-10-02 19:22

You can use the column alias if you want a more expressive title for data For exampleSelect ename,sal,empno ,sal+100 bounceFrom empOrder by bounce;ENAME &n&hell…Read More

DESC Keyword

2011-10-02 19:16

The default sort order is ascending when using the ORDER BY clause , you can reverse the order in which rows are displayed by using the DESC keywords. It placed after column name in the ORDE… Read More

Order By

2011-10-02 19:07

We used order by clause to sort rows in an order that you specify.Sorting data is ascending order by .1- Numeric data is sorted from the lowest to the highest number… Read More

RULES OF PRIORITY

2011-10-02 19:02

IN SQL SELECT statement the oracle server evaluates comparison operator’s begor logival operators.In the evaluation of logical operators ,NOT is evaluated first,AND is evaluated second… Read More

Logical Operators

2011-10-02 18:59

Logical operators in SQLAnd Used to define conditions that must all be true for a row to be retrieved. OR Used to define two conditions of which only one must be true for a row to b… Read More

Is Null Operator

2011-10-02 18:53

COMPARE NULL IN SQLIf you want to find out if a column contains any null values, then you can use the is NULL operator in the where clause.A null value means that the value is unavailable. Y… Read More

LIKE

2011-09-29 15:44

When you don’t know what value you need to search then you can use the like operator in where cluse.Symbols with like.(%) represents any number of characters(_) the underscore sym… Read More

IN

2011-09-29 15:43

IN IN Operator used to restrict rows retrieved to values in specified list The IN keyword is followed by values separated by commas.The full list of values is enclosed within a single s… Read More

BETWEEN

2011-09-29 15:39

BETWEEN SQL RANGE used to display rows based on a rang of values,you use the between and keywords . You specify the between keyword followed by the lower limit of the range, and k… Read More

Comparing Expression

2011-09-29 15:38

Comparing in sql = Equal < Less than > Greater than <= Less than or equal >= Greater than or equal <> Not equal By using these operators you ca… Read More

Where

2011-09-27 20:02

WhereYou can restrict the rows returned from a query by using a where clause in SQL statement By inserting a WHERE clause into a SQL statement, you can specify a condition that must be met… Read More

Data Type

2011-09-27 19:53

Data type SQL DATATYPESNUMBER: INDICATE THE COLUMN CONTAINS NUMBER. EXAMPLE: NUMBER (6, 2) 32155.01The number in parentheses following this data type refers to the maximum of digits th… Read More

DISPLAYING TABLE STRUCTURE

2011-09-26 16:59

DISPLAYING TABLE STRUCTURE. Structure of sql.You can use the DESCRIBE command to see the column names, the data types ,And whether a column must contain data from a s… Read More

Oracle Sql Tutorials,oracle 10g Tutorial Blog

Find My Code