iSelfSchooling.com - Since 1999  References  |  Job Openings
    Home  | Search more  | Oracle Syntax  | Computer Institute   | (Login or Register to access to VIDEOS)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

  ShareUrNotes

...

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

Topics:  Hands-On 02 - Developer Tools (Query Builder)

Query Builder facilitates you to write your simple or complex query.  You can save your query at your client-side.  It allows you to set your table relationships and visualize your database objects that being linked, including the tables, columns, and datatypes.

In this Hands-On, you will learn how to:  Create a query, Join Multiple tables (the “dept” table and the “emp” table), Set table relationship, Execute Query, Sort query, Add where clause condition, Listing query, Saving query.

 

More Resources by Google:

Manuscript

Open the “Query Builder” tool.

 

Login as “iself” password schooling, and then click “CONNECT.”

 

Click on the “OK” button.

 

Click "OK" to create new query.

 

Select the "department" table and then click on “include.”

Select the “Employee” table and click on “include.”

Close the window.

 

Maximize the "Query Builder" window.

 

Click on the "set table relationship” icon.

Type “dept.deptno” the department number of the department table on the "A" box; and “emp.deptno” the department number of the employee table on the "B" box.

Then Click "OK."

 

Select the department name column, the employee name column and the salary column.

 

Click on the “Show SQL” icon.

 

Notice:  The “where” clause in the sql statement.

 

Click "execute."

Check the output.

 

Click on the "department name" column.

Choose the "sort ascending” icon; and then go to the “Show SQL” window and execute the query.  Table was sorted.

Close the window.

 

Click on the condition box and

add a “where” clause to display all the employees of the sales department whom their salaries are more than 2000.

 

Press the enter key.

Click on the “Show SQL” icon.

 

Notice:  The where clause condition were added to the “sql” statement.

Execute the statement.

 

Check the output and close the “Show SQL” window.

 

Click on the “Query” window; and then

choose the “File” option and click on “Save as” or “Save” to save the query in the “iself” folder.

 

Click “OK.”

 

Name the file “emp_salary” and click on “Save;” and exit From “Query Builder.”

 

Now, you should practice this over and over, until you become a master at it.

Good Luck.

 

 
 
Google
 
Web web site