Topics by butterflyTee

FROM: ORACLE 9i Give the SQL statements that determine the following: 1. Which customers lives in New Jersey? SELECT * customer FROM customers WHERE state = 'NJ' 2.Which orders were shipped after April 1, 2003 SELECT * FROM orders WHERE shipdate to_date('01/04/2003', DD/MM/YYYY') 3. Which books are not in Fitness Category? SELECT * FROM books WHERE category != < 'Fitness' 4.Which customers live in either Georgia or New Jersey? Put the results in ascending order by last name. SELECT * FROM customers WHERE states IN ('GA or 'NJ') ORDER BY "LName" asce 5. Which orders were place before April 2, …

i have tried to answer this question like this (show your attempt) and i did it like this because (show your reasons why you think it is the correct approach) and the results that it gave are like this (show the results that your query produces) and i cannot understand why i am getting the wrong results. [CODE]USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title …

##USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title of each book & the name and phone number of the person at the publisher's office whom you would need to contact to record each book. SELECT title, name, customer FROM books NATURAL JOIN publisher WHERE books.pubid = publisher.pubid AND c.books = record Determine which orders have not yet shipped & the name of the customer that …

USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title of each book & the name and phone number of the person at the publisher's office whom you would need to contact to record each book. SELECT title, name, customer FROM books JOIN publisher WHERE books.pubid = publisher.pubid AND c.books = record Determine which orders have not yet shipped & the name of the customer that placed …

Did I do this right and can you please help me. This program uses a GUI to input a user's first and last name, and construct and display a UserID. Although the program 'runs', there are several problems with it. Fix each of these problems in turn: 1) The text and corresponding entry box for 'Last Name' does not align with those for 'First Name'. Correct this. 2) Provide the code to draw a Rectangle around the 'button' text object, so that it looks like a button. 3) The program as written always produces the same UserID, 'frodo'. Change this …

I need help please to write this program. Numerologists claim to be able to determine a person's character traits based on the "numeric value" of a name. The value of a name is determined by summing up the vaules of the letters of the name where 'a' is 1, 'b' is 2, 'c' 3 etc., up to 'z' being 26. For example, the name "Zelle" would have the value 26+5+12+12+5=60. Write a program that calculates the numeric value of a single name provided as input. I am using my name Tamika. Then, I have to expand my solution to the …

Word Count. A Common Utility On Unix/linux Systems Is A Small Program Called "wc." This Program Analyzes A File To Determine The Number Of Lines, Words, And Characters Contained Therein. Write A Version Of Wc. The Program Should Accept A File Name As Input And Than Print Three Numbers Showing The Count Of Lines, Words, And Characters In The File. I use Gettysburg address. [CODE]#The number of lines, and the number of words. import string def main(): data = raw_input("Enter the path and name of your ") infile = file(data, 'r') data_file = infile.read() number_of_characters = len(data_file) print "The number …