Databases | SQL | Oracle | MS Access Answers

program to print all odd no from 1 and n

Write a pl/sql to check a given no is positive negative or zero

Write a pl/sql to find out whether a given n0. is palindrome or not using while structure

Write a pl/sql to print all nos. those are divisible by 3 and not by 5
from 1 to 100 except 15

List the team names and the total number of players from the team who played less than 20 minutes on the ground in the last two years (the current year and last year). The season attribute in the database is VARCHAR(5) to allow for sports which run multiple seasons within a calendar year, such seasons are coded as, for example: 2001S, 2001W (note that the first four characters are always the year). Name the columns as 'TEAM NAME' and 'LESS THAN 20 COUNT'. Sort the output according to the 'LESS THAN 20 COUNT' column, teams with have the same count should be ordered by team name.

Explore the SQL and Oracle security tools and then compare them?????

PLEASE HELP ME WITH MY ASSIGNMENT
CREATE THE FOLLOWING BARCODE USING LOOP AND TWO FUNCTION SUBSTRAND MOD CHECKER THIS IS THE:
ttp://www.gs1.org/barcodes/support/check_digit_calculator,

what is diffrent between SQL and SQL plus?.

1. Consider the following relation schema:
Employee (emp_name, emp_street, emp_city)
Works (emp_name, Company_name, salary)
Company (company_name, city)
Manager(emp_name, manager_name)
For each of the following queries, write SQL statements:
i. Find the name of all employees who work for First Bank Corporation
ii. Find the name and city of residence of all employees who work for First Bank Corporation.
iii. Find the name, street, city of residence of all employees who work for First Bank Corporation
and earn more than Rs 15,000 per month.
iv. Find all such employees who do not work for First Bank Corporation.
v. Find the name of all employees who lives in the same city as the company they work for.
vi. Find the company with smallest payroll.
vii. Find all employees who earn more than all employees of Small Bank Corporation.
viii. Assuming that a company may be located in several cities, find the name of the companies that
are locate in every city where Small Bank Corporation is located.
ix. Find the company with maximum number of branches.
x. Find the company that have maximum employees.

Area of a rectangle with integer values for its sides, is 8 times its perimeter.
What are its sides ?