Order Your Email : Order By « Query Select « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Query Select
  3. Order By
SQL>
SQL> CREATE TABLE email (e   VARCHAR(50));

Table created.

SQL> INSERT INTO email VALUES ('I@napier.ac.uk');

1 row created.

SQL> INSERT INTO email VALUES ('P.Bhardwaj@napier.ac.uk');

1 row created.

SQL> INSERT INTO email VALUES ('Scott@rbs.co.uk');

1 row created.

SQL> INSERT INTO email VALUES ('Alan@rbs.co.uk');

1 row created.

SQL> INSERT INTO email VALUES ('abc@s.com');

1 row created.

SQL>
SQL> SELECT SUBSTR(e,1+INSTR(e,'.',-1)),e
  2    FROM email;

SUBSTR(E,1+INSTR(E,'.',-1))
--------------------------------------------------
E
--------------------------------------------------
uk
I@napier.ac.uk

uk
P.Bhardwaj@napier.ac.uk

uk
Scott@rbs.co.uk


SUBSTR(E,1+INSTR(E,'.',-1))
--------------------------------------------------
E
--------------------------------------------------
uk
Alan@rbs.co.uk

com
abc@s.com


SQL>
SQL> DROP TABLE email;

Table dropped.

SQL>








2.4.Order By
2.4.1.Sorting Rows Using the ORDER BY Clause
2.4.2.Sort last name ascending
2.4.3.Sort last name descending
2.4.4.Sort one column ascending and another column descending
2.4.5.Sort by index ascending and descending
2.4.6.Reference alias name in order by clause
2.4.7.Order by a calculated column
2.4.8.Sort the rows by descending order with DESC appended to order by clause
2.4.9.Sort two columns with different ordering
2.4.10.Use a column position number in the ORDER BY clause
2.4.11.A SELECT with Ordering
2.4.12.Order the table on the employee's original salary (orig_salary)
2.4.13.Order by two columns
2.4.14.Add aggregate function in order by clause
2.4.15.Order by username
2.4.16.Combine order by clause with case statement
2.4.17.Order Your Email