Search & Filtering
Databases | SQL | Oracle | MS Access
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,
CREATE THE FOLLOWING BARCODE USING LOOP AND TWO FUNCTION SUBSTRAND MOD CHECKER THIS IS THE:
ttp://www.gs1.org/barcodes/support/check_digit_calculator,
Databases | SQL | Oracle | MS Access
what is diffrent between SQL and SQL plus?.
Databases | SQL | Oracle | MS Access
I have 4 fields in my database "distcode, empid,DLno,PANno" . In some cases dlno is blank (or with dashes like "--") and in some cases panno is blank , most of the cases both numbers are greater than 4 characters . and here empid is a primary key .can you plz tell me in total for a particular dist how many employees have dlno and panno(both should greater than 4 character)
Databases | SQL | Oracle | MS Access
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.
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.
Databases | SQL | Oracle | MS Access
Relation: A(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
Dependencies:
1, 2 → 3, 4, 5, 6, 7, 8, 9, 10
1 → 3, 4, 5
2 → 6, 10
4 → 5
8 → 9
Write the relations and reference statements in 3NF.
Dependencies:
1, 2 → 3, 4, 5, 6, 7, 8, 9, 10
1 → 3, 4, 5
2 → 6, 10
4 → 5
8 → 9
Write the relations and reference statements in 3NF.
Databases | SQL | Oracle | MS Access
hi i need help i need to create table using combinations of Cursors, Loops, Inserts, Variables, If-Else conditions that will display a table below
Employee Name Customer ID Order ID Order Date Order Amount Running Total
Employee 1 Customer 1 Order 1 1/1/2000 2,500 2,500
Order 2 1/1/2000 3,000 5,500
Order 3 1/1/2000 5,000 10,500
Customer 2 Order 4 1/2/2000 500 500
Customer 3 Order 5 1/2/2000 500 500
Order 6 1/3/2000 500 1,000
Employee 2 Customer 1 Order 7 1/1/2005 900 900
Customer 5 Order 8 1/2/2005 1,500 1,500
Order 9 1/3/2005 2,000 3,500
Employee Name Customer ID Order ID Order Date Order Amount Running Total
Employee 1 Customer 1 Order 1 1/1/2000 2,500 2,500
Order 2 1/1/2000 3,000 5,500
Order 3 1/1/2000 5,000 10,500
Customer 2 Order 4 1/2/2000 500 500
Customer 3 Order 5 1/2/2000 500 500
Order 6 1/3/2000 500 1,000
Employee 2 Customer 1 Order 7 1/1/2005 900 900
Customer 5 Order 8 1/2/2005 1,500 1,500
Order 9 1/3/2005 2,000 3,500
Databases | SQL | Oracle | MS Access
i am to develop a timetable for my school as a project work using My SQL Server 2008 and Microsoft visual studio 2010. I really do not no how to go about it and so i'm pleading that you help out. thanks
Databases | SQL | Oracle | MS Access
I've created a table called students which has a column for GPA. I have to write the following for each student. "Congratulations Bill, your grade point average is 3.45. You'll need to use the TO_CHAR function to convert the GPA column (which is a NUMBER data type) to a set of characters."
How would I start to write the first one? I've tried everything and I can't get anything to work.
How would I start to write the first one? I've tried everything and I can't get anything to work.
Databases | SQL | Oracle | MS Access
I've created a table called students which has a column for GPA. I have to write the following for each student. "Congratulations Bill, your grade point average is 3.45. You'll need to use the TO_CHAR function to convert the GPA column (which is a NUMBER data type) to a set of characters."
How would I start to write the first one? I've tried everything and I can't get anything to work.
How would I start to write the first one? I've tried everything and I can't get anything to work.
Databases | SQL | Oracle | MS Access
I'm using oracle 10g and I need to write a number of statements as such:
Congratulations Bill, your grade point average is 3.45. You'll need to use the TO_CHAR function to convert the GPA column (which is a NUMBER data type) to a set of characters.
I've created the following tables:
INSERT INTO students VALUES (101, 'Bill', 'CMIS', 3.45, 102);
INSERT INTO students VALUES (102, 'Mary', 'CMIS', 3.10, NULL);
INSERT INTO students VALUES (103, 'Sue', 'Marketing', 2.95, 102);
INSERT INTO students VALUES (104, 'Tom', 'Finance', 3.5, 106);
INSERT INTO students VALUES (105, 'Alex', 'CMIS', 2.75, 106);
INSERT INTO students VALUES (106, 'Sam', 'Marketing', 3.25, 103);
INSERT INTO students VALUES (107, 'Jane', 'Finance', 2.90, 102);
Now I'm totally lost as to how to display the user's GPA along with the sentence. Does anyone know where to start?
Congratulations Bill, your grade point average is 3.45. You'll need to use the TO_CHAR function to convert the GPA column (which is a NUMBER data type) to a set of characters.
I've created the following tables:
INSERT INTO students VALUES (101, 'Bill', 'CMIS', 3.45, 102);
INSERT INTO students VALUES (102, 'Mary', 'CMIS', 3.10, NULL);
INSERT INTO students VALUES (103, 'Sue', 'Marketing', 2.95, 102);
INSERT INTO students VALUES (104, 'Tom', 'Finance', 3.5, 106);
INSERT INTO students VALUES (105, 'Alex', 'CMIS', 2.75, 106);
INSERT INTO students VALUES (106, 'Sam', 'Marketing', 3.25, 103);
INSERT INTO students VALUES (107, 'Jane', 'Finance', 2.90, 102);
Now I'm totally lost as to how to display the user's GPA along with the sentence. Does anyone know where to start?
