Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (((((((((((((((((((((((((((((((((NASA)))))))))))))))))))))))))))))))))
- Conection:www.nasa.gov
- ----------------------------------------------------------------------------------------------------------
- drop table accept;
- drop table rank;
- drop table reject cascade constraints;
- drop table ansedit;
- drop table answer;
- drop table defer cascade constraints;
- drop table delinquency cascade constraints;
- drop table pass cascade constraints;
- drop table quesedit;
- drop table quesword;
- drop table question;
- drop table status;
- drop table directory;
- drop table expword;
- drop table experiment;
- drop table glevel;
- drop table linkword;
- drop table link;
- drop table keyword;
- drop table interests;
- drop table area;
- drop table reply;
- drop table message;
- drop table moderator;
- drop table hold;
- drop table scientist;
- drop table member;
- drop table users;
- drop table position;
- drop table institute;
- drop table zip;
- drop table country;
- ----------------------------------------------------------------------------------------------------------
- CREATE TABLE COUNTRY (
- COUNTRY_NO char(3) constraint country_pk primary key,
- NAME varchar2(25) constraint country_name_null not null);
- CREATE TABLE ZIP (
- ZIP_NO char(8) constraint zip_pk primary key,
- CITY varchar2(25) constraint zip_city_null not null,
- STATE varchar2(25) constraint zip_state_null not null,
- ZIP_CODE char(8) constraint zip_code_null not null,
- COUNTRY_NO char(3) constraint zip_countryno_null not null
- constraint zip_countryno_fk references country);
- ----------------------------------------------------------------------------------------------------------
- AREA_NO char(2) constraint exp_areano_null not null
- ----------------------------------------------------------------------------------------------------------
- insert into country values(1,'U.S.A.')
- insert into country values(2,'Taiwan')
- insert into country values(3,'Japan')
- insert into country values(4,'China')
- insert into country values(5,'Koera')
- insert into country values(6,'Germany')
- insert into institute values(1,'Washington University');
- insert into institute values(2,'US Department of Defense');
- insert into institute values(3,'USC Department of Industrial Engineering');
- insert into institute values(4,'USC Department of Computer Science');
- insert into institute values(5,'Oregon State University');
- insert into institute values(6,'Los Angeles City College');
- insert into institute values(7,'Pasadena City College');
- insert into institute values(8,'National Dr. Sun Yat-sen University');
- insert into institute values(9,'California Back Specialists');
- insert into institute values(10,'Los Angeles Public Libarary');
- insert into institute values(11,'Ohio State University');
- ---------------------------------------------------------------------------------------------------------
- insert into area values(1,'Agricultural Science','');
- insert into area values(2,'Anatomy','');
- insert into area values(3,'Astronomy','');
- insert into area values(4,'Biochemistry','');
- insert into area values(5,'Biophysics','');
- insert into area values(6,'Botany','');
- insert into area values(7,'Chemistry','');
- insert into area values(8,'Cell Biology','');
- insert into area values(9,'Computer Science','');
- insert into area values(10,'Development','');
- insert into area values(11,'Earch Science/Geology','');
- insert into area values(12,'Engineering','');
- insert into area values(13,'Environment/Ecology','');
- insert into area values(14,'Evolution','');
- insert into area values(15,'Genetics','');
- insert into area values(16,'General Biology','');
- insert into area values(17,'Immunology','');
- insert into area values(18,'Medicine','');
- insert into area values(19,'Microbiology','');
- insert into area values(20,'Molecular Biology','');
- insert into area values(21,'Neuroscience','');
- insert into area values(22,'Physics','');
- insert into area values(23,'Virology','');
- insert into area values(24,'Zoology','');
- insert into area values(25,'Science History','');
- insert into area values(26,'Anthropology','');
- insert into area values(27,'Archaeology','');
- insert into area values(28,'Entomology','');
- insert into area values(29,'Meteorology','');
- insert into area values(30,'Oceanography','');
- insert into area values(31,'Paleontology','');
- insert into area values(32,'Psychology','');
- ---------------------------------------------------------------------------------------------------------
- INFO:http://www.nasa.gov/ ',' El sitio de la NASA está llena de imágenes e información acerca de misiones de transbordador, el espacio de Hubble
- ---------------------------------------------------------------------------------------------------------
- insert into directory values('1', 'archives/jan 2000');
- insert into directory values('2', 'archives/feb 2000');
- insert into directory values('3', 'archives/march 2000');
- insert into directory values('4', 'archives/oct 2000');
- insert into directory values('5', 'archives/nov 2000');
- insert into directory values('6', 'archives');
- insert into directory values('7', 'current Q');
- insert into status values('1', 'posted' );
- insert into status values('2', 'pending' );
- insert into status values('3', 'deleted' );
- ---------------------------------------------------------------------------------------------------------
- (SELECT MODERATOR.MEMBER_ID ID, FIRST_NAME||' '||LAST_NAME MODERATOR_NAME
- FROM MEMBER,MODERATOR
- WHERE MEMBER.MEMBER_ID=MODERATOR.MEMBER_ID
- MINUS
- SELECT MODERATOR.MEMBER_ID ID, FIRST_NAME||' '||LAST_NAME MODERATOR_NAME
- FROM MEMBER,MODERATOR,PASS
- WHERE MEMBER.MEMBER_ID=MODERATOR.MEMBER_ID
- AND MODERATOR.MEMBER_ID=PASS.MOD_ID)
- INTERSECT
- (SELECT MODERATOR.MEMBER_ID ID, FIRST_NAME||' '||LAST_NAME MODERATOR_NAME
- FROM MEMBER,MODERATOR
- WHERE MEMBER.MEMBER_ID=MODERATOR.MEMBER_ID
- MINUS
- SELECT MODERATOR.MEMBER_ID ID, FIRST_NAME||' '||LAST_NAME MODERATOR_NAME
- FROM MEMBER,MODERATOR,QUESEDIT
- WHERE MEMBER.MEMBER_ID=MODERATOR.MEMBER_ID
- AND MODERATOR.MEMBER_ID=QUESEDIT.MEMBER_ID);
- ---------------------------------------------------------------------------------------------------------
Add Comment
Please, Sign In to add comment