As I warned in class, they are a bit sparse (and text only), but here
they are,
--Chris
-- ____________________________________________________________...
Hi all-- I was contacted by a local business looking for a database programmer. The job seems to involve writing some Visual Basic code for a GPS database....
I was wondering if there is anything wrong with the following answers to Part A (5) b/c they look very different than the solution posted online. RA: PROJECT...
I was wondering if (and if so what) is wrong with the following answer to Part A (5): RA: PROJECT r_name ( SELECT score > avg_score ( RATINGS * EATER ) ) ...
Just from the little bit I looked at it, it's because your RA answer returns all restaurants that have had anyone that rated them higher than average. The...
If y'all are like me and prefer to use a graphical interface as opposed to the command line stuff and have therefore downloaded Oracle's SQL Developer, you're...
if i have a variable ... Declare myVariable mytable.colname%type Begin select colname into myVariable from mytable where colname='yadda' ... if there were no...
What is the acceptable edit distance value form A to B for this task? For example is this value 2? I didn't find a defined value in the project description....
You can use "IS NULL" or "IS NOT NULL". IF myVariable IS NULL then .... END IF; If myVariable contains a null value, the "IF" expression evaluates to TRUE. ...
Hi, I'm getting the error that says ORA-04077: WHEN clause cannot be used with table level triggers on the first problem. This is the sample code I'm using for...
The problem is that if you have a "WHEN", then it needs to be a so-called "row-level" trigger that fires separately for each row or tuple in the database......
You could use to_date(), to_char(), to_number() and substr() functions. to_date(date, format) -- returns a date is specified format substr(s,start,len) --...
I think the errors you are getting now are due to some syntax mistakes. A couple of them I could catch: 1. line six: missing "'" at end of string 2. when...
Be sure you don't have a space after the dot in dbms_output.putline(' '); Other than that, you might want to be sure to have checked that you enabled server...
Hi all-- In Oracle, if you subtract two dates you get the difference between them in days (or fractions of days). So to do #1 in the HW, just compare the...
Hi all-- Just a reminder that as was discussed in class yesterday, assignment 3 will be due before class next Tuesday. Assignment 4 will still be assigned...
I have No idea what is wrong. Here is the stripped down trigger.. ... CREATE OR REPLACE TRIGGER myTrigger BEFORE INSERT ON sightings FOR EACH ROW DECLARE ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
