Jump to content
xisto Community

darkwarrior

Members
  • Content Count

    37
  • Joined

  • Last visited

Everything posted by darkwarrior

  1. We don't have many Wiggers in England, at least not where I live. Our infestation is what we call 'scallies'. Scruffy kids, all think they're 20 at the age of 11, smoke, drink and hang around with their track-pants tucked into their sucks while wearing school shoes and 'Schott' hoodies....I would enjoy hurting them.Yes.
  2. You are joking right? Movies and books are any less time-consuming and more a valid way to spend time than Games?Why?Because its made up purely of text? It invokes imagination?Because 16 cars get blown up within the opening 15 minutes?Games are nothing less and noting more than a book or a movie except that they allow us to REALLY escape and they require skill too. Very little time in life is actually spent escaping zombies, surviving an earthquake laden city or secreting your way into Soviet territory and thats how people get to go have fun.People have lives but if they want to spend their recreation time playing a game instead of sitting on a corner in a hoodie looking like a moron in the cold, then power to them.There are far worse ways to spend your time than enjoying a great story or having to use your skills.
  3. Its quite possibly the greatest game to ever exist on any console ever so far. In fact the only reason it isn't perfect right now is the limitations of current gen hard ware compared to their vision for GTA.
  4. Sooooo close.I've playued this already through 'alternative' means on my friends PS2 and so far its been a lot of fun. I think the thing that will hurt it most is its totally ghetto atmosphere. They swear in between every other word which isn't totally necessary and I'm not a fan of the sound track either.Vice City, despite being led by an apparently italian guy, was open, you didn't care what nationality it was, it wasn't rubbed in your face like it is in GTA:SA so it was just your character.The customisation however is AWESOME!
  5. I was interested in this game but honestly I'm having more fun modifying it than I did playing it. The playing just seemed to get boring and nothing much ever seemed to unlock for me either so its just on my HD now for modding purposes.Nice game, guess it just requires more patience than I have available.
  6. I was just curious what I was limited to. I'm attempting to build a site there but since I go to uni part time and study databases, I thought I could use a table to my mysql to allow me to run a few scripts and save them for work. I'm not sure if that is against TOS or not, if so I apologise and won't continue. However, when I tried to run the code given to me to create the table I am meant to work on it basically just mocks my syntax and spits in my face. The syntax is: REM Order of creation from hr_main[/br]REM changed by Pam Quick July 2003[br]SET SERVEROUTPUT ON VERIFY OFF[/br]rem drop all tables views[br]DROP VIEW emp_details_view;[/br]DROP SEQUENCE departments_seq;[br]DROP SEQUENCE employees_seq;[/br]DROP SEQUENCE locations_seq;[br]DROP TABLE regions CASCADE CONSTRAINTS;[/br]DROP TABLE departments CASCADE CONSTRAINTS;[br]DROP TABLE locations CASCADE CONSTRAINTS;[/br]DROP TABLE jobs CASCADE CONSTRAINTS;[br]DROP TABLE job_grades CASCADE CONSTRAINTS;[/br]DROP TABLE job_history CASCADE CONSTRAINTS;[br]DROP TABLE employees CASCADE CONSTRAINTS;[/br]DROP TABLE countries CASCADE CONSTRAINTS; [br]DROP TABLE job_grades CASCADE CONSTRAINTS;[/br]rem create all tables[br]SET FEEDBACK 1[/br]SET NUMWIDTH 10[br]SET LINESIZE 80[/br]SET PAGESIZE 100[br]SET ECHO OFF [/br]REM ********************************************************************[br]REM Create the REGIONS table to hold region information for locations[/br]REM HR.LOCATIONS table has a foreign key to this table.[br]Prompt ****** Creating REGIONS table ....[/br]CREATE TABLE regions[br] ( region_id NUMBER [/br] CONSTRAINT region_id_nn NOT NULL [br] , region_name VARCHAR2(25) [/br] );[br]CREATE UNIQUE INDEX reg_id_pk[/br]ON regions (region_id);[br]ALTER TABLE regions[/br]ADD ( CONSTRAINT reg_id_pk[br] PRIMARY KEY (region_id)[/br] );[br]REM ********************************************************************[/br]REM Create the COUNTRIES table to hold country information for customers[br]REM and company locations. [/br]REM OE.CUSTOMERS table and HR.LOCATIONS have a foreign key to this table.[br]Prompt ****** Creating COUNTRIES table ....[/br]CREATE TABLE countries [br] ( country_id CHAR(2) [/br] CONSTRAINT country_id_nn NOT NULL [br] , country_name VARCHAR2(40) [/br] , region_id NUMBER [br] , CONSTRAINT country_c_id_pk [/br] PRIMARY KEY (country_id) [br] ) [/br] ORGANIZATION INDEX; [br][/br]ALTER TABLE countries[br]ADD ( CONSTRAINT countr_reg_fk[/br] FOREIGN KEY (region_id)[br] REFERENCES regions(region_id) [/br] );[br]REM ********************************************************************[/br]REM Create the LOCATIONS table to hold address information for company departments.[br]REM HR.DEPARTMENTS has a foreign key to this table.[/br]Prompt ****** Creating LOCATIONS table ....[br]CREATE TABLE locations[/br] ( location_id NUMBER(4)[br] , street_address VARCHAR2(40)[/br] , postal_code VARCHAR2(12)[br] , city VARCHAR2(30)[/br] CONSTRAINT loc_city_nn NOT NULL[br] , state_province VARCHAR2(25)[/br] , country_id CHAR(2)[br] );[/br]CREATE UNIQUE INDEX loc_id_pk[br]ON locations (location_id);[/br]ALTER TABLE locations[br]ADD ( CONSTRAINT loc_id_pk[/br] PRIMARY KEY (location_id)[br] );[/br]Rem Useful for any subsequent addition of rows to locations table[br]Rem Starts with 3300[/br]CREATE SEQUENCE locations_seq[br] START WITH 3300[/br] INCREMENT BY 100[br] MAXVALUE 9900[/br] NOCACHE[br] NOCYCLE;[br]REM ********************************************************************[/br]REM Create the DEPARTMENTS table to hold company department information.[/br]REM HR.EMPLOYEES and HR.JOB_HISTORY have a foreign key to this table.[br]Prompt ****** Creating DEPARTMENTS table ....[/br]CREATE TABLE departments[br] ( department_id NUMBER(4)[/br] , department_name VARCHAR2(30)[br] CONSTRAINT dept_name_nn NOT NULL[/br] , manager_id NUMBER(6)[br] , location_id NUMBER(4)[br] );[/br]CREATE UNIQUE INDEX dept_id_pk[/br]ON departments (department_id);[br]ALTER TABLE departments[/br]ADD ( CONSTRAINT dept_id_pk[br] PRIMARY KEY (department_id)[/br] , CONSTRAINT dept_loc_fk[br] FOREIGN KEY (location_id)[/br] REFERENCES locations (location_id)[br] );[/br]Rem Useful for any subsequent addition of rows to departments table[br]Rem Starts with 280 [/br]CREATE SEQUENCE departments_seq[br] START WITH 280[/br] INCREMENT BY 10[br] MAXVALUE 9990[/br] NOCACHE[br] NOCYCLE;[br]REM ********************************************************************[/br]REM Create the JOBS table to hold the different names of job roles within the company.[/br]REM HR.EMPLOYEES has a foreign key to this table.[br]Prompt ****** Creating JOBS table ....[/br]CREATE TABLE jobs[br] ( job_id VARCHAR2(10)[/br] , job_title VARCHAR2(35)[br] CONSTRAINT job_title_nn NOT NULL[/br] , min_salary NUMBER(6)[br] , max_salary NUMBER(6)[br] );[/br]CREATE UNIQUE INDEX job_id_pk [/br]ON jobs (job_id);[br]ALTER TABLE jobs[/br]ADD ( CONSTRAINT job_id_pk[br] PRIMARY KEY(job_id)[/br] );[br]REM ********************************************************************[/br]REM Create the EMPLOYEES table to hold the employee personnel [br]REM information for the company.[/br]REM HR.EMPLOYEES has a self referencing foreign key to this table.[br]Prompt ****** Creating EMPLOYEES table ....[/br]CREATE TABLE employees[br] ( employee_id NUMBER(6)[/br] , first_name VARCHAR2(20)[br] , last_name VARCHAR2(25)[/br] CONSTRAINT emp_last_name_nn NOT NULL[br] , email VARCHAR2(25)[/br] CONSTRAINT emp_email_nn NOT NULL[br] , phone_number VARCHAR2(20)[/br] , hire_date DATE[br] CONSTRAINT emp_hire_date_nn NOT NULL[/br] , job_id VARCHAR2(10)[br] CONSTRAINT emp_job_nn NOT NULL[/br] , salary NUMBER(8,2)[br] , commission_pct NUMBER(2,2)[/br] , manager_id NUMBER(6)[br] , department_id NUMBER(4)[/br] , CONSTRAINT emp_salary_min[br] CHECK (salary > 0) [/br] , CONSTRAINT emp_email_uk[br] UNIQUE (email)[/br] ); [br][/br]CREATE UNIQUE INDEX emp_emp_id_pk[br]ON employees (employee_id);[br][/br][/br]ALTER TABLE employees[br]ADD ( CONSTRAINT emp_emp_id_pk[/br] PRIMARY KEY (employee_id)[br] , CONSTRAINT emp_dept_fk[/br] FOREIGN KEY (department_id)[br] REFERENCES departments[/br] , CONSTRAINT emp_job_fk[br] FOREIGN KEY (job_id)[/br] REFERENCES jobs (job_id)[br] , CONSTRAINT emp_manager_fk[/br] FOREIGN KEY (manager_id)[br] REFERENCES employees[/br] );[br][/br]ALTER TABLE departments[br]ADD ( CONSTRAINT dept_mgr_fk[/br] FOREIGN KEY (manager_id)[br] REFERENCES employees (employee_id)[br] );[/br]Rem Useful for any subsequent addition of rows to employees table[/br]Rem Starts with 207 [br]CREATE SEQUENCE employees_seq[/br] START WITH 207[br] INCREMENT BY 1[/br] NOCACHE[br] NOCYCLE;[br]REM ********************************************************************[/br]REM Create the JOB_HISTORY table to hold the history of jobs that [/br]REM employees have held in the past.[br]REM HR.JOBS, HR_DEPARTMENTS, and HR.EMPLOYEES have a foreign key to this table.[/br]Prompt ****** Creating JOB_HISTORY table ....[br]CREATE TABLE job_history[/br] ( employee_id NUMBER(6)[br] CONSTRAINT jhist_employee_nn NOT NULL[/br] , start_date DATE[br] CONSTRAINT jhist_start_date_nn NOT NULL[/br] , end_date DATE[br] CONSTRAINT jhist_end_date_nn NOT NULL[/br] , job_id VARCHAR2(10)[br] CONSTRAINT jhist_job_nn NOT NULL[/br] , department_id NUMBER(4)[br] , CONSTRAINT jhist_date_interval[/br] CHECK (end_date > start_date)[br] );[/br]CREATE UNIQUE INDEX jhist_emp_id_st_date_pk [br]ON job_history (employee_id, start_date);[/br]ALTER TABLE job_history[br]ADD ( CONSTRAINT jhist_emp_id_st_date_pk[/br] PRIMARY KEY (employee_id, start_date)[br] , CONSTRAINT jhist_job_fk[br] FOREIGN KEY (job_id)[/br] REFERENCES jobs[/br] , CONSTRAINT jhist_emp_fk[br] FOREIGN KEY (employee_id)[/br] REFERENCES employees[br] , CONSTRAINT jhist_dept_fk[/br] FOREIGN KEY (department_id)[br] REFERENCES departments[/br] );[br]REM ********************************************************************[/br]REM Create the EMP_DETAILS_VIEW that joins the employees, jobs, [br]REM departments, jobs, countries, and locations table to provide details[/br]REM about employees.[br][/br]Prompt ****** Creating EMP_DETAILS_VIEW view ...[br][/br]CREATE OR REPLACE VIEW emp_details_view[br] (employee_id,[/br] job_id,[br] manager_id,[/br] department_id,[br] location_id,[/br] country_id,[br] first_name,[/br] last_name,[br] salary,[/br] commission_pct,[br] department_name,[/br] job_title,[br] city,[/br] state_province,[br] country_name,[/br] region_name)[br]AS SELECT[/br] e.employee_id, [br] e.job_id, [/br] e.manager_id, [br] e.department_id,[/br] d.location_id,[br] l.country_id,[/br] e.first_name,[br] e.last_name,[/br] e.salary,[br] e.commission_pct,[/br] d.department_name,[br] j.job_title,[/br] l.city,[br] l.state_province,[/br] c.country_name,[br] r.region_name[/br]FROM[br] employees e,[/br] departments d,[br] jobs j,[/br] locations l,[br] countries c,[/br] regions r[br]WHERE e.department_id = d.department_id[/br] AND d.location_id = l.location_id[br] AND l.country_id = c.country_id[/br] AND c.region_id = r.region_id[br] AND j.job_id = e.job_id [/br]WITH READ ONLY;[br][/br]rem[br]rem job-grades table added by p.quick[/br]rem[br]CREATE TABLE JOB_GRADES[/br](GRADE_LEVEL VARCHAR2(3) PRIMARY KEY,[br]LOWEST_SAL NUMBER(6),[/br]HIGHEST_SAL NUMBER(6));[br][/br]COMMIT;[br]rem populate all tables[/br]REM ***************************insert data into the REGIONS table[br]Prompt ****** Populating REGIONS table ....[/br]INSERT INTO regions VALUES [br] ( 1[/br] , 'Europe' [br] );[/br]INSERT INTO regions VALUES [br] ( 2[/br] , 'Americas' [br] );[/br]INSERT INTO regions VALUES [br] ( 3[/br] , 'Asia' [br] );[/br]INSERT INTO regions VALUES [br] ( 4[/br] , 'Middle East and Africa' [br] );[/br]REM ***************************insert data into the COUNTRIES table[br]Prompt ****** Populating COUNTIRES table ....[/br]INSERT INTO countries VALUES [br] ( 'US'[/br] , 'United States of America'[br] , 2 [br] );[/br]INSERT INTO countries VALUES [/br] ( 'CA'[br] , 'Canada'[/br] , 2 [br] );[/br]INSERT INTO countries VALUES [br] ( 'UK'[/br] , 'United Kingdom'[br] , 1 [br] );[/br]INSERT INTO countries VALUES [/br] ( 'DE'[br] , 'Germany'[/br] , 1 [br] );[/br]REM ***************************insert data into the LOCATIONS table[br]Prompt ****** Populating LOCATIONS table ....[/br]INSERT INTO locations VALUES [br] ( 1400 [/br] , '2014 Jabberwocky Rd'[br] , '26192'[/br] , 'Southlake'[br] , 'Texas'[/br] , 'US'[br] );[/br]INSERT INTO locations VALUES [br] ( 1500 [/br] , '2011 Interiors Blvd'[br] , '99236'[/br] , 'South San Francisco'[br] , 'California'[/br] , 'US'[br] );[/br]INSERT INTO locations VALUES [br] ( 1700 [/br] , '2004 Charade Rd'[br] , '98199'[/br] , 'Seattle'[br] , 'Washington'[/br] , 'US'[br] );[/br]INSERT INTO locations VALUES [br] ( 1800 [/br] , '147 Spadina Ave'[br] , 'M5V 2L7'[/br] , 'Toronto'[br] , 'Ontario'[/br] , 'CA'[br] );[/br]INSERT INTO locations VALUES [br] ( 2500 [/br] , 'Magdalen Centre, The Oxford Science Park'[br] , 'OX9 9ZB'[/br] , 'Oxford'[br] , 'Oxford'[/br] , 'UK'[br] );[/br]REM ****************************insert data into the DEPARTMENTS table[br]Prompt ****** Populating DEPARTMENTS table ....[/br]REM disable integrity constraint to EMPLOYEES to load data[br]ALTER TABLE departments [/br] DISABLE CONSTRAINT dept_mgr_fk;[br]INSERT INTO departments VALUES [/br] ( 10[br] , 'Administration'[/br] , 200[br] , 1700[br] );[/br]INSERT INTO departments VALUES [/br] ( 20[br] , 'Marketing'[/br] , 201[br] , 1800[/br] ); [br]INSERT INTO departments VALUES [/br] ( 50[br] , 'Shipping'[/br] , 121[br] , 1500[/br] ); [br]INSERT INTO departments VALUES [/br] ( 60 [br] , 'IT'[/br] , 103[br] , 1400[/br] ); [br]INSERT INTO departments VALUES [/br] ( 80 [br] , 'Sales'[/br] , 145[br] , 2500[/br] ); [br]INSERT INTO departments VALUES [/br] ( 90 [br] , 'Executive'[/br] , 100[br] , 1700[/br] ); [br]INSERT INTO departments VALUES [/br] ( 110 [br] , 'Accounting'[/br] , 205[br] , 1700[br] );[/br]INSERT INTO departments VALUES [/br] ( 190 [br] , 'Contracting'[/br] , NULL[br] , 1700[br] );[/br]REM ***************************insert data into the JOBS table[/br]Prompt ****** Populating JOBS table ....[br]INSERT INTO jobs VALUES [/br] ( 'AD_PRES'[br] , 'President'[/br] , 20000[br] , 40000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'AD_VP'[br] , 'Administration Vice President'[/br] , 15000[br] , 30000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'AD_ASST'[br] , 'Administration Assistant'[/br] , 3000[br] , 6000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'AC_MGR'[br] , 'Accounting Manager'[/br] , 8200[br] , 16000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'AC_ACCOUNT'[br] , 'Public Accountant'[/br] , 4200[br] , 9000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'SA_MAN'[br] , 'Sales Manager'[/br] , 10000[br] , 20000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'SA_REP'[br] , 'Sales Representative'[br] , 6000[/br] , 12000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'ST_MAN'[br] , 'Stock Manager'[/br] , 5500[br] , 8500[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'ST_CLERK'[br] , 'Stock Clerk'[/br] , 2000[br] , 5000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'SH_CLERK'[br] , 'Shipping Clerk'[br] , 2500[/br] , 5500[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'IT_PROG'[br] , 'Programmer'[/br] , 4000[br] , 10000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'MK_MAN'[br] , 'Marketing Manager'[br] , 9000[/br] , 15000[br] );[/br]INSERT INTO jobs VALUES [/br] ( 'MK_REP'[br] , 'Marketing Representative'[/br] , 4000[br] , 9000[br] );[/br]REM ***************************insert data into the EMPLOYEES table[/br]Prompt ****** Populating EMPLOYEES table ....[br]INSERT INTO employees VALUES [/br] ( 100[br] , 'Steven'[/br] , 'King'[br] , 'SKING'[/br] , '515.123.4567'[br] , TO_DATE('17-JUN-1987', 'dd-MON-yyyy')[/br] , 'AD_PRES'[br] , 24000[/br] , NULL[br] , NULL[/br] , 90[br] );[/br]INSERT INTO employees VALUES [br] ( 101[/br] , 'Neena'[br] , 'Kochhar'[/br] , 'NKOCHHAR'[br] , '515.123.4568'[/br] , TO_DATE('21-SEP-1989', 'dd-MON-yyyy')[br] , 'AD_VP'[/br] , 17000[br] , NULL[/br] , 100[br] , 90[br] );[/br]INSERT INTO employees VALUES [/br] ( 102[br] , 'Lex'[/br] , 'De Haan'[br] , 'LDEHAAN'[/br] , '515.123.4569'[br] , TO_DATE('13-JAN-1993', 'dd-MON-yyyy')[br] , 'AD_VP'[/br] , 17000[br] , NULL[/br] , 100[/br] , 90[br] );[/br]INSERT INTO employees VALUES [br] ( 103[/br] , 'Alexander'[br] , 'Hunold'[/br] , 'AHUNOLD'[br] , '590.423.4567'[/br] , TO_DATE('03-JAN-1990', 'dd-MON-yyyy')[br] , 'IT_PROG'[br] , 9000[/br] , NULL[/br] , 102[br] , 60[br] );[/br]INSERT INTO employees VALUES [/br] ( 104[br] , 'Bruce'[/br] , 'Ernst'[br] , 'BERNST'[/br] , '590.423.4568'[br] , TO_DATE('21-MAY-1991', 'dd-MON-yyyy')[/br] , 'IT_PROG'[br] , 6000[/br] , NULL[br] , 103[/br] , 60[br] );[/br]INSERT INTO employees VALUES [br] ( 107[/br] , 'Diana'[br] , 'Lorentz'[/br] , 'DLORENTZ'[br] , '590.423.5567'[/br] , TO_DATE('07-FEB-1999', 'dd-MON-yyyy')[br] , 'IT_PROG'[/br] , 4200[br] , NULL[/br] , 103[br] , 60[br] );[/br]INSERT INTO employees VALUES [/br] ( 124[br] , 'Kevin'[/br] , 'Mourgos'[br] , 'KMOURGOS'[/br] , '650.123.5234'[br] , TO_DATE('16-NOV-1999', 'dd-MON-yyyy')[/br] , 'ST_MAN'[br] , 5800[br] , NULL[/br] , 100[/br] , 50[br] );[/br]INSERT INTO employees VALUES [br] ( 141[/br] , 'Trenna'[br] , 'Rajs'[/br] , 'TRAJS'[br] , '650.121.8009'[/br] , TO_DATE('17-OCT-1995', 'dd-MON-yyyy')[br] , 'ST_CLERK'[/br] , 3500[br] , NULL[/br] , 124[br] , 50[br] );[/br]INSERT INTO employees VALUES [/br] ( 142[br] , 'Curtis'[/br] , 'Davies'[br] , 'CDAVIES'[/br] , '650.121.2994'[br] , TO_DATE('29-JAN-1997', 'dd-MON-yyyy')[br] , 'ST_CLERK'[/br] , 3100[br] , NULL[/br] , 124[/br] , 50[br] );[/br]INSERT INTO employees VALUES [br] ( 143[/br] , 'Randall'[br] , 'Matos'[/br] , 'RMATOS'[br] , '650.121.2874'[/br] , TO_DATE('15-MAR-1998', 'dd-MON-yyyy')[br] , 'ST_CLERK'[/br] , 2600[br] , NULL[/br] , 124[br] , 50[br] );[/br]INSERT INTO employees VALUES [/br] ( 144[br] , 'Peter'[/br] , 'Vargas'[br] , 'PVARGAS'[/br] , '650.121.2004'[br] , TO_DATE('09-JUL-1998', 'dd-MON-yyyy')[/br] , 'ST_CLERK'[br] , 2500[/br] , NULL[br] , 124[/br] , 50[br] );[/br]INSERT INTO employees VALUES [br] ( 149[/br] , 'Eleni'[br] , 'Zlotkey'[/br] , 'EZLOTKEY'[br] , '011.44.1344.429018'[/br] , TO_DATE('29-JAN-2000', 'dd-MON-yyyy')[br] , 'SA_MAN'[/br] , 10500[br] , .2[br] , 100[/br] , 80[br] );[/br]INSERT INTO employees VALUES [/br] ( 174[br] , 'Ellen'[/br] , 'Abel'[br] , 'EABEL'[/br] , '011.44.1644.429267'[br] , TO_DATE('11-MAY-1996', 'dd-MON-yyyy')[/br] , 'SA_REP'[br] , 11000[/br] , .30[br] , 149[/br] , 80[br] );[/br]INSERT INTO employees VALUES [br] ( 176[/br] , 'Jonathon'[br] , 'Taylor'[/br] , 'JTAYLOR'[br] , '011.44.1644.429265'[/br] , TO_DATE('24-MAR-1998', 'dd-MON-yyyy')[br] , 'SA_REP'[/br] , 8600[br] , .20[br] , 149[/br] , 80[br] );[/br]INSERT INTO employees VALUES [/br] ( 178[br] , 'Kimberely'[/br] , 'Grant'[br] , 'KGRANT'[/br] , '011.44.1644.429263'[br] , TO_DATE('24-MAY-1999', 'dd-MON-yyyy')[br] , 'SA_REP'[/br] , 7000[/br] , .15[br] , 149[/br] , NULL[br] );[/br]INSERT INTO employees VALUES [br] ( 200[/br] , 'Jennifer'[br] , 'Whalen'[/br] , 'JWHALEN'[br] , '515.123.4444'[/br] , TO_DATE('17-SEP-1987', 'dd-MON-yyyy')[br] , 'AD_ASST'[/br] , 4400[br] , NULL[/br] , 101[br] , 10[br] );[/br]INSERT INTO employees VALUES [/br] ( 201[br] , 'Michael'[/br] , 'Hartstein'[br] , 'MHARTSTE'[/br] , '515.123.5555'[br] , TO_DATE('17-FEB-1996', 'dd-MON-yyyy')[/br] , 'MK_MAN'[br] , 13000[br] , NULL[/br] , 100[/br] , 20[br] );[/br]INSERT INTO employees VALUES [br] ( 202[/br] , 'Pat'[br] , 'Fay'[/br] , 'PFAY'[br] , '603.123.6666'[/br] , TO_DATE('17-AUG-1997', 'dd-MON-yyyy')[br] , 'MK_REP'[br] , 6000[/br] , NULL[/br] , 201[br] , 20[br] );[/br]INSERT INTO employees VALUES [/br] ( 205[br] , 'Shelley'[/br] , 'Higgins'[br] , 'SHIGGINS'[/br] , '515.123.8080'[br] , TO_DATE('07-JUN-1994', 'dd-MON-yyyy')[/br] , 'AC_MGR'[br] , 12000[/br] , NULL[br] , 101[/br] , 110[br] );[/br]INSERT INTO employees VALUES [br] ( 206[/br] , 'William'[br] , 'Gietz'[/br] , 'WGIETZ'[br] , '515.123.8181'[br] , TO_DATE('07-JUN-1994', 'dd-MON-yyyy')[/br] , 'AC_ACCOUNT'[/br] , 8300[br] , NULL[/br] , 205[br] , 110[br] );[/br]COMMIT;[/br]REM ********* insert data into the JOB_HISTORY table[br]Prompt ****** Populating JOB_HISTORY table ....[/br]INSERT INTO job_history[br]VALUES (102[/br] , TO_DATE('13-JAN-1993', 'dd-MON-yyyy')[br] , TO_DATE('24-JUL-1998', 'dd-MON-yyyy')[/br] , 'IT_PROG'[br] , 60);[/br]INSERT INTO job_history[br]VALUES (101[/br] , TO_DATE('21-SEP-1989', 'dd-MON-yyyy')[br] , TO_DATE('27-OCT-1993', 'dd-MON-yyyy')[/br] , 'AC_ACCOUNT'[br] , 110);[/br]INSERT INTO job_history[br]VALUES (101[/br] , TO_DATE('28-OCT-1993', 'dd-MON-yyyy')[br] , TO_DATE('15-MAR-1997', 'dd-MON-yyyy')[/br] , 'AC_MGR'[br] , 110);[/br]INSERT INTO job_history[br]VALUES (201[/br] , TO_DATE('17-FEB-1996', 'dd-MON-yyyy')[br] , TO_DATE('19-DEC-1999', 'dd-MON-yyyy')[/br] , 'MK_REP'[br] , 20);[/br]INSERT INTO job_history[br]VALUES (200[/br] , TO_DATE('17-SEP-1987', 'dd-MON-yyyy')[br] , TO_DATE('17-JUN-1993', 'dd-MON-yyyy')[br] , 'AD_ASST'[/br] , 90[br] );[/br]INSERT INTO job_history[/br]VALUES (176[br] , TO_DATE('24-MAR-1998', 'dd-MON-yyyy')[/br] , TO_DATE('31-DEC-1998', 'dd-MON-yyyy')[br] , 'SA_REP'[/br] , 80[br] );[/br]INSERT INTO job_history[br]VALUES (176[/br] , TO_DATE('01-JAN-1999', 'dd-MON-yyyy')[br] , TO_DATE('31-DEC-1999', 'dd-MON-yyyy')[br] , 'SA_MAN'[/br] , 80[br] );[/br]INSERT INTO job_history[br]VALUES (200[/br] , TO_DATE('01-JUL-1994', 'dd-MON-yyyy')[/br] , TO_DATE('31-DEC-1998', 'dd-MON-yyyy')[br] , 'AC_ACCOUNT'[/br] , 90[br] );[/br]prompt***********Populating JOB_GRADES table****************[br]INSERT INTO JOB_GRADES VALUES[/br]('A',1000,2999);[br]INSERT INTO JOB_GRADES VALUES[/br]('B',3000,5999);[br]INSERT INTO JOB_GRADES VALUES[/br]('C',6000,9999);[br]INSERT INTO JOB_GRADES VALUES[/br]('D',10000,14999);[br]INSERT INTO JOB_GRADES VALUES[/br]('E',15000,24999);[br]INSERT INTO JOB_GRADES VALUES[/br]('F',25000,40000);[br]COMMIT;[/br]/ Is it for a too early version or there just permission restrictions in place? Advice is appreciated and thankyou in advance.
  7. AHHHHHHHHHHHHHHHHH Awesome, thanks much. Xisto.com/cpanel won't work anymore but using your site address/cpanel works a charm.Thanks again!
  8. For some reason I can't log into CPanel, it just keeps saying either the ID or PW is wrong but I know they aren't. Yet it won't have anything of it. Please help
  9. Not everything has to be compared to GTA and I don't think Mafia was based on GTA at all anyway. Apart from being set in a city it has nothing in common with it from style or gameplay. You don't walk away from car crashes.The game is a master piece of story-telling through games but the missions are pretty much trial and error. Until you activate enemies, they stay where they are so if you do die, just re-load and start again knowing where they will be and so knowing to dive, roll and shoot, etc.Its still a great game though, hooked me. I hear Mafia 2 is in the works.
  10. Allow me to seperate your feelings.Van Helsing was awful. High budget but its story was overly camp. In the 40's or 50's it would've worked but it, like Sky Captain, fail miserably because its not what the public wants to see anymore.Don't waste your money. Get Blade.
  11. It's not delayed, thats its actual release date. GTA is and always has been PS2 exclsuive. Noone else gets it until its been out for at least a few months on the PS2. XBOX didn't get GTA3 until VC had been out like a year and they released that GTA double pack.And thats the way I likes it
  12. MIchael Jackson is a great artist but he needs to sort his life out and he definetly needs to finalize his current cases before attempting to sue Eminem.
  13. I hate racing games but the first turned me onto a whole new world. Mostly because of the customisation/story-line. Racing in itself is boring, why I never got into Gran Turismo. I look forwrd to NFS:U 2 BUT I hope to god that the linear upgrading is gone. Making your car look pretty is great and all but when it ORDERS you to upgrade before continuing and no matter what brand you pick it doesn't alter performance, its a little dull.
  14. It somehow sorted itself out. Thanks for hte advice guys, I think I decided against PHP Nuke anyway, didn't seem very user friendly to me.
  15. Ok then, Thanks for your input guys. I was worried it would grant people access to behind the scenes files is all but now I see I should be ok.
  16. I'm experiencing some problems with my installations. From the pre-installed scripts available I have installed PunBB and PHP nuke and cannot login to either. Is this because they aren't in the Public_html?Only reason they aren't installed there is because it said I had to install to a top level directory and typing public_html/forum is considered illegal.Any help?
  17. Ok, I've been messing around a bit with my space today, uploading scripts and what not but what I'm not 100% on is where do I put all my content, layouts, everything basically?Does it all go in Public_HTML? Will it not work in the root directory? And if it goes in Public_HTML will people be able to gain access to scripts and such?Thx in advance.
  18. I was just curious as to what hte purpose of name servers is?
  19. Strange, doesn't it open at Christmas? Would have thought we'd have heard more about it by now.There is no other trailer available right now though at all.
  20. You Forgot OINK.Also, though its fun, its best to just be polite. Police can cause so much hassle for you when they abuse their power because you wound them up.
  21. I just watched RE: Apocalypse. T'was Ok but I think it might help the script a little if the writer wasn't doing the star. Nemesis is a fan-favourite and he was pushed aside along with Jill and Carlos and all the others for Alice.Stupid Anderson. Must Kill.But if you're a fan of hte games or action flicks, its average and worth watching.
  22. I dunno, it was kinda funny. Maybe I'm just not a 'forum-*BLEEP*' who gets that kind of stuff :)Clever presentation though. Should help keep newbs in check.
  23. They reviewed it? Doesn't it come out in like...a long time?It looks ok but I prefer my FPS on PC, easier and more fun. Consoles are for platforming/racing/fighting.
  24. Postal 2 wasn't a bad game. It had a funny story-line, great characters and concept (what there was) I mean you could pretty much go where you wanted and do what you wanted and I think every single building was accessible. It even had Gary Coleman.The only bad point to Postal 2 was the loading, I have to agree. Loading between each zone and despite my high end PC it still took ages.
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.