Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

Oracle Induction Essay

  • Submitted by: eminemdev
  • on September 3, 2013
  • Category: Miscellaneous
  • Length: 367 words

Open Document

Below is an essay on "Oracle Induction" from Anti Essays, your source for research papers, essays, and term paper examples.

Oracle

What is Oracle 11g?

Oracle 11g is an RDBMS.

Structured Query Language (SQL)

Users can communicate with an RDBMS using SQL, which enables you to access and manipulate databases.

How do you access Oracle 11g?

With your mouse pointer go through the following trail:

Windows button -> All Programs -> Oracle-OraDb11g_home1 -> Application Development -> SQL Plus

For user name enter: scott.

For password enter: tiger.

If you need a host string, it will be given to you during the lab.

Do the following before working with queries

    ✓ Take your mouse pointer to the SQL Plus icon at the top left corner of the window and right-click the icon. Then select Layout. Enter the following values:


          For Width under Screen Buffer Size, enter 120.


          For Height under Screen Buffer Size, enter 300.


          For Width under Window Size, enter 120.


          For Height under Window Size, enter 60.


    ✓ At the SQL prompt, type: set linesize 100

      This allows 100 characters to be displayed per line.

      Then at the SQL prompt, type: set pagesize 20

      This allows 20 lines to be displayed per page.

We do the above to make data in tables easy to read.



Data Retrieval using SQL

The select statement is used to retrieve data from a table.

  select
  from
  [where ];


Selecting specific columns
  select ename, empno, mgr, deptno
  from emp;


Selecting all columns
  select *
  from emp;

Limiting the Rows Selected
• Restrict the rows returned by using the where clause.

  select empno, ename, job
  from emp
  where deptno = 20;


  select ename, mgr, deptno
  from emp
  where job = ‘MANAGER’;


Operators
• Relational operators
• Logical operators

Relational Operators
=
>
>=
<
= ’01-jan-1980’;

Joining Tables Using Oracle Syntax
• Use a join to query data from more than one table.

select table1.column, table2.column
from table1,...

Show More


Citations

MLA Citation

"Oracle Induction". Anti Essays. 13 Dec. 2018

<http://parimatchstavki7.com/free-essays/Oracle-Induction-508241.html>

APA Citation

Oracle Induction. Anti Essays. Retrieved December 13, 2018, from the World Wide Web: http://parimatchstavki7.com/free-essays/Oracle-Induction-508241.html