Archive for January 2016

SQL ORACLE QUERIES

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's request. This chapter provides background information on SQL as used by most database systems.
Oracle SQL Developer provides a SQL Worksheet that you can use to query data, by writing simple or complex SQL statements. In this How-To, we look at the most basic of these, select all the data in a table, and restricting this query by reducing the columns or rows you retrieve.


TASK - 1:

1. Create the following table customer
2. Create the following table product
3. Create the following table cust_prod

TASK - 2:

1.   Find out the names of all customers
13. Find out the customers who stay in ‘Chennai‘andwhose name starts with ‘S’



TASK-5



TASK-7









Friday, 22 January 2016
Posted by Pratik Badala

Follow by Email

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Google+ Followers

Translate

Powered by Blogger.

- Copyright © All Notes on BCA - Metrominimalist - Powered by Blogger - Designed by Johanes Djogan -