## Archive for 2016

## Graphics Programming Dev C++

Even though some peoples somehow managed to port it outside the turbo. Some people hacked their own version of graphics.h. One such person is Micheal main, he ported some of borland graphics functions and library. Micheal main modified BGI library for windows application to be used under MinGW. This BGI library is renamed as WinBGIm. Now you can use all the borland specific functions under Dev-C++.

__Using the WinBGIm Graphics Library with Dev-C++__

*Installation Notes:*- Install Dev-C++. I installed from the Version 4.9.9.2 Setup File.
- Download graphics.h to the include/ subdirectory of the Dev-C++ directories.
- Download libbgi.a to the lib/ In order to use the WinBGIm subdirectory of the Dev-C++ directories. Whenever you #include <graphics.h> in a program, you must instruct the linker to link in certain libraries. The command to do so from Dev-C++ is Alt-P. Choose the Parameters tab from the pop-up window and type the following into the Linker area:

-lbgi

-lgdi32

-lcomdlg32

-luuid

-loleaut32

-lole32

#include <graphics.h> int main( ) { initwindow(400, 300, "First Sample"); outtextxy(200,300,"My first Graphics Program in Dev C++..."); while (!kbhit( )) { delay(200); } return 0; }

4. You can now compile and run programs that use the WinBGIm graphics library, such as this one that opens a small window, draws a circle and waits for the user to press a key:

**Some Basic Programs Using Graphics**1. Draw a filled rectangle.

2. Draw a rectangle unfilled.

3. Draw concentric circles.

*Some Programs Using Graphics*

2. Kite Moving

3. Pie Chart Drawing

*Some Programs Using Graphics Algorithm*1. Bresenham Line Draw Algorithm With Program.

2. Mid Point Circle's Algorithm With Program.

3. Mid Point Line Draw Algorithm With Program

4. Boundary Fill's Algorithm With Program.

5. Flood Fill Algorithm With Program.

6. Translation Perform on 2D Transformations With Program.

7. Scaling Perform on 2D Transformations With Program.

8. Refletion Perform on 2D Transformations With Program.

9. Shear Perform on 2D Transformations With Program.

10. Rotation Perform on 2D Transformations With Program.

8. Refletion Perform on 2D Transformations With Program.

9. Shear Perform on 2D Transformations With Program.

10. Rotation Perform on 2D Transformations With Program.

## 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’

2. Create Table order

3. Create Table sales_order_details

2. Display one month later than the order date.

3. Print the month of delivery date of all the products.

1. Display the number of products in each order

2. Display the order number with number ofproducts more than 2

1. Find out the product which has been sold to particular customer.

2. Find out the product and their quantities that have to be delivered.

3. Find out the product number and description of ordered products

4. Find out the names of clients who have purchased “CD DRIVE”

5. List the product number and sales order number of customers having quantity ordered less than 5 from the order details table for the product “1.44 floppy”.

6. Find the products and their quantities for the orders placed by particular sales man.

7. Find the products and their quantities for the orders placed by client number “C00001” and “C00002”.

16. Count the total number of products

17. Calculate the average price of the products

18. List the product which has minimum price

19. List the product that has maximum price

20. Count the number of products having the unit price greater than 2000.

17. Calculate the average price of the products

18. List the product which has minimum price

19. List the product that has maximum price

20. Count the number of products having the unit price greater than 2000.

__TASK - 3:__**1. Create Table Salesman**

2. Create Table order

3. Create Table sales_order_details

__TASK-4:__**1. How many days are taken to deliver the product from ordered date?**

2. Display one month later than the order date.

3. Print the month of delivery date of all the products.

4. Display the customer name in upper case.

5. Print the product description with right padded symbols.

6. Print the first three characters of customer names.

7. Print the length of longest customer name.

8. Print the delivery date in the format 22nd January 2016.

5. Print the product description with right padded symbols.

6. Print the first three characters of customer names.

7. Print the length of longest customer name.

8. Print the delivery date in the format 22nd January 2016.

__TASK-5__1. Display the number of products in each order

2. Display the order number with number ofproducts more than 2

3. List the Salesman number who had sold maximum products

4. List the minimum, maximum, average and total price of product purchased by each customer (use cust_prod table).

5. List the total price of each customer whose product purchased is more than 5.

6. Display the salesman number who have anorder and whose name starts with ‘A’

4. List the minimum, maximum, average and total price of product purchased by each customer (use cust_prod table).

5. List the total price of each customer whose product purchased is more than 5.

6. Display the salesman number who have anorder and whose name starts with ‘A’

9. Find the total value of each productsold.

10. Display the product number and number ofproducts ordered for each product.

10. Display the product number and number ofproducts ordered for each product.

__TASK-6__1. Find out the product which has been sold to particular customer.

2. Find out the product and their quantities that have to be delivered.

3. Find out the product number and description of ordered products

4. Find out the names of clients who have purchased “CD DRIVE”

5. List the product number and sales order number of customers having quantity ordered less than 5 from the order details table for the product “1.44 floppy”.

6. Find the products and their quantities for the orders placed by particular sales man.

7. Find the products and their quantities for the orders placed by client number “C00001” and “C00002”.

__TASK-7__
2. Find the customer name, address, city and pincode for the client who has placed order number “XXX”.

3. Find the clients who have placed order before the month of May 2016.

4. Find out if product “xxx” is ordered by only client and print the client number, name to whom it was sold.

4. Find out if product “xxx” is ordered by only client and print the client number, name to whom it was sold.