如何理解嵌套子查询?(How to understand nested subqueries?)
我想了解子查询,并且我认为我理解了以前的问题,但现在我想了解嵌套子查询,现在我比我更困惑。
我正在尝试做这样的输出:
Model Year --------------------------- ------------ Grand Caravan 2010 Q70 2015
我试图找到这些的方式是通过这些描述:GPS,加热座椅和AWD。
目前我没有选择行。
我的陈述如下所示:
SELECT t1.MODELNAME AS Model, t2.VEHICLEYEAR AS Year FROM TBLMODEL t1 FULL JOIN TBLVEHICLE t2 ON t1.MODELID = t2.MODELID FULL JOIN TBLOPTIONDETAIL t3 ON t2.VEHICLEID = t3.VEHICLEID FULL JOIN TBLOPTION t4 ON t3.OPTIONID = t4.OPTIONID WHERE t4.OPTIONDESC IN ( SELECT OPTIONDESC FROM TBLOPTION WHERE OPTIONDESC = 'GPS' AND OPTIONDESC = ( SELECT OPTIONDESC FROM TBLOPTION WHERE OPTIONDESC = 'Heated Seats' ) );
它对应的文件:
DROP TABLE tblOptionDetail; DROP TABLE tblOption; DROP TABLE tblVehicle; DROP TABLE tblModel; DROP TABLE tblBrand; DROP TABLE tblManufacture; CREATE TABLE tblManufacture ( ManufactureID NUMBER(38) PRIMARY KEY, ManufactureName CHAR(40) ); CREATE TABLE tblBrand ( BrandID NUMBER(38) PRIMARY KEY, ManufactureID NUMBER(38), BrandName CHAR(40), FOREIGN KEY (ManufactureID) REFERENCES tblManufacture(ManufactureID) ); CREATE TABLE tblModel ( ModelID NUMBER(38) PRIMARY KEY, BrandID NUMBER(38), ModelName CHAR(40), FOREIGN KEY (BrandID) REFERENCES tblBrand(BrandID) ); CREATE TABLE tblVehicle ( VehicleID NUMBER(38) PRIMARY KEY, ModelID NUMBER(38), VehicleYear NUMBER(38) CHECK (VehicleYear BETWEEN 1900 and 3000), VehicleKM NUMBER(38) CHECK (VehicleKM BETWEEN 0 and 100000000), VehiclePrice NUMBER(38) CONSTRAINT carprice CHECK (VehiclePrice BETWEEN 0 and 1000000), FOREIGN KEY (ModelID) REFERENCES tblModel(ModelID) ); CREATE TABLE tblOption ( OptionID NUMBER(38) PRIMARY KEY, OptionDesc CHAR(40) ); CREATE TABLE tblOptionDetail ( OptionID NUMBER(38), VehicleID NUMBER(38), PRIMARY KEY (OptionID, VehicleID), FOREIGN KEY (OptionID) REFERENCES tblOption(OptionID), FOREIGN KEY (VehicleID) REFERENCES tblVehicle(VehicleID) ); -- populate the Manufacture table INSERT ALL INTO tblManufacture (ManufactureID, ManufactureName) VALUES (1,'Chrysler Corp.') INTO tblManufacture (ManufactureID, ManufactureName) VALUES(2,'General Motors') INTO tblManufacture (ManufactureID, ManufactureName) VALUES(3,'Ford Motor Company') INTO tblManufacture (ManufactureID, ManufactureName) VALUES(4,'Toyota') INTO tblManufacture (ManufactureID, ManufactureName) VALUES (5,'Honda') INTO tblManufacture (ManufactureID, ManufactureName) VALUES (6,'Nisan') SELECT * FROM dual; -- populate the Brand table INSERT ALL INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (1,1, 'Chrysler') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (2,1, 'Dodge') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (3,1, 'Jeep') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (4,2, 'Chevrolet') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (5,2, 'Buick') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (6,2, 'Cadillac') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (7,2, 'GMC') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (8,4, 'Toyota') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (9,6, 'Nissan') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (10,6,'Infiniti') SELECT * FROM dual; -- populate the Model table INSERT ALL INTO tblModel (ModelID, BrandID, ModelName) VALUES (1,1, '200') INTO tblModel (ModelID, BrandID, ModelName) VALUES (2,1, '200 Convertible') INTO tblModel (ModelID, BrandID, ModelName) VALUES (3,1, '300') INTO tblModel (ModelID, BrandID, ModelName) VALUES (4,1, 'Town'||' & '||'Country') INTO tblModel (ModelID, BrandID, ModelName) VALUES (5,2, 'Durango') INTO tblModel (ModelID, BrandID, ModelName) VALUES (6,2, 'Avenger') INTO tblModel (ModelID, BrandID, ModelName) VALUES (7,2, 'Challenger') INTO tblModel (ModelID, BrandID, ModelName) VALUES (8,2, 'Charger') INTO tblModel (ModelID, BrandID, ModelName) VALUES (9,2, 'Caliber') INTO tblModel (ModelID, BrandID, ModelName) VALUES (10,2, 'Grand Caravan') INTO tblModel (ModelID, BrandID, ModelName) VALUES (11,2, 'Journey') INTO tblModel (ModelID, BrandID, ModelName) VALUES (12,4, 'Sonic') INTO tblModel (ModelID, BrandID, ModelName) VALUES (13,4, 'Cruze') INTO tblModel (ModelID, BrandID, ModelName) VALUES (14,4, 'Orlando') INTO tblModel (ModelID, BrandID, ModelName) VALUES (15,4, 'Colorado') INTO tblModel (ModelID, BrandID, ModelName) VALUES (16,4, 'Malibu') INTO tblModel (ModelID, BrandID, ModelName) VALUES (17,8, '4Runner') INTO tblModel (ModelID, BrandID, ModelName) VALUES (18,8, 'Prius') INTO tblModel (ModelID, BrandID, ModelName) VALUES (19,8, 'Camry') INTO tblModel (ModelID, BrandID, ModelName) VALUES (20,8, 'Corolla') INTO tblModel (ModelID, BrandID, ModelName) VALUES (21,9,'Rogue SL') INTO tblModel (ModelID, BrandID, ModelName) VALUES (22,9, 'Versa Note') INTO tblModel (ModelID, BrandID, ModelName) VALUES (23,9, 'Pathfinder') INTO tblModel (ModelID, BrandID, ModelName) VALUES (24,9, 'Altima') INTO tblModel (ModelID, BrandID, ModelName) VALUES (25,10, 'Q70') INTO tblModel (ModelID, BrandID, ModelName) VALUES (26,10, 'Q50') INTO tblModel (ModelID, BrandID, ModelName) VALUES (27,10, 'Q60') INTO tblModel (ModelID, BrandID, ModelName) VALUES (28,10, 'EX37') SELECT * FROM dual; -- populate Option table INSERT ALL INTO tblOption (OptionID,OptionDesc) VALUES (1,'Power locks') INTO tblOption (OptionID,OptionDesc) VALUES (2,'Power windows') INTO tblOption (OptionID,OptionDesc) VALUES (3,'Air conditioning') INTO tblOption (OptionID,OptionDesc) VALUES (4,'Heated mirrors') INTO tblOption (OptionID,OptionDesc) VALUES (5,'Remote keyless entry') INTO tblOption (OptionID,OptionDesc) VALUES (6,'CD Player') INTO tblOption (OptionID,OptionDesc) VALUES (7,'GPS') INTO tblOption (OptionID,OptionDesc) VALUES (8,'In-dash DVD player') INTO tblOption (OptionID,OptionDesc) VALUES (9,'Overhead DVD player') INTO tblOption (OptionID,OptionDesc) VALUES (10,'Satellite radio') INTO tblOption (OptionID,OptionDesc) VALUES (11,'MP3 player') INTO tblOption (OptionID,OptionDesc) VALUES (12,'Antilock braking system') INTO tblOption (OptionID,OptionDesc) VALUES (13,'Electronic stability system') INTO tblOption (OptionID,OptionDesc) VALUES (14,'Traction control') INTO tblOption (OptionID,OptionDesc) VALUES (15,'Cruise control') INTO tblOption (OptionID,OptionDesc) VALUES (16,'Intelligent cruise control') INTO tblOption (OptionID,OptionDesc) VALUES (17,'Parking assist system') INTO tblOption (OptionID,OptionDesc) VALUES (18,'Xenon headlights') INTO tblOption (OptionID,OptionDesc) VALUES (19,'Aluminum rims') INTO tblOption (OptionID,OptionDesc) VALUES (20,'AWD') INTO tblOption (OptionID,OptionDesc) VALUES (21,'Convertable') INTO tblOption (OptionID,OptionDesc) VALUES (22,'Heated Seats') SELECT * FROM dual; -- populate Vehicle table INSERT ALL INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (1,10, 2010, 45000, 18000) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (2,10, 2010, 65420, 17500) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (3,16, 2004, 143900, 3200) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (4,11, 2010, 38900, 14500) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (5,27,2014,17250,45999) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (6,25,2015,2900,62300) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (7,17,2010,87900,19800) SELECT * FROM dual; -- populate OptionDetail table INSERT ALL INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (5, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (7, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (8, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (11, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (11, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (4,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (8,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (5,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (21,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (22,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1,7) INTO tblOptionDetail (OptionID, VehicleID) VALUES (4,7) INTO tblOptionDetail (OptionID, VehicleID) VALUES (5,7) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2,7) SELECT * FROM dual; COMMIT;
I am trying to understand subqueries, and I thought I understood the issues I had before, but now I want to understand nested subqueries and now I am even more confused than I was.
I am trying to make an output like this:
Model Year --------------------------- ------------ Grand Caravan 2010 Q70 2015
The way I af trying to find these are through these descriptions: GPS, Heated Seats, and AWD.
Currently I am getting no rows selected.
My statement is as shown:
SELECT t1.MODELNAME AS Model, t2.VEHICLEYEAR AS Year FROM TBLMODEL t1 FULL JOIN TBLVEHICLE t2 ON t1.MODELID = t2.MODELID FULL JOIN TBLOPTIONDETAIL t3 ON t2.VEHICLEID = t3.VEHICLEID FULL JOIN TBLOPTION t4 ON t3.OPTIONID = t4.OPTIONID WHERE t4.OPTIONDESC IN ( SELECT OPTIONDESC FROM TBLOPTION WHERE OPTIONDESC = 'GPS' AND OPTIONDESC = ( SELECT OPTIONDESC FROM TBLOPTION WHERE OPTIONDESC = 'Heated Seats' ) );
The file it corresponds to:
DROP TABLE tblOptionDetail; DROP TABLE tblOption; DROP TABLE tblVehicle; DROP TABLE tblModel; DROP TABLE tblBrand; DROP TABLE tblManufacture; CREATE TABLE tblManufacture ( ManufactureID NUMBER(38) PRIMARY KEY, ManufactureName CHAR(40) ); CREATE TABLE tblBrand ( BrandID NUMBER(38) PRIMARY KEY, ManufactureID NUMBER(38), BrandName CHAR(40), FOREIGN KEY (ManufactureID) REFERENCES tblManufacture(ManufactureID) ); CREATE TABLE tblModel ( ModelID NUMBER(38) PRIMARY KEY, BrandID NUMBER(38), ModelName CHAR(40), FOREIGN KEY (BrandID) REFERENCES tblBrand(BrandID) ); CREATE TABLE tblVehicle ( VehicleID NUMBER(38) PRIMARY KEY, ModelID NUMBER(38), VehicleYear NUMBER(38) CHECK (VehicleYear BETWEEN 1900 and 3000), VehicleKM NUMBER(38) CHECK (VehicleKM BETWEEN 0 and 100000000), VehiclePrice NUMBER(38) CONSTRAINT carprice CHECK (VehiclePrice BETWEEN 0 and 1000000), FOREIGN KEY (ModelID) REFERENCES tblModel(ModelID) ); CREATE TABLE tblOption ( OptionID NUMBER(38) PRIMARY KEY, OptionDesc CHAR(40) ); CREATE TABLE tblOptionDetail ( OptionID NUMBER(38), VehicleID NUMBER(38), PRIMARY KEY (OptionID, VehicleID), FOREIGN KEY (OptionID) REFERENCES tblOption(OptionID), FOREIGN KEY (VehicleID) REFERENCES tblVehicle(VehicleID) ); -- populate the Manufacture table INSERT ALL INTO tblManufacture (ManufactureID, ManufactureName) VALUES (1,'Chrysler Corp.') INTO tblManufacture (ManufactureID, ManufactureName) VALUES(2,'General Motors') INTO tblManufacture (ManufactureID, ManufactureName) VALUES(3,'Ford Motor Company') INTO tblManufacture (ManufactureID, ManufactureName) VALUES(4,'Toyota') INTO tblManufacture (ManufactureID, ManufactureName) VALUES (5,'Honda') INTO tblManufacture (ManufactureID, ManufactureName) VALUES (6,'Nisan') SELECT * FROM dual; -- populate the Brand table INSERT ALL INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (1,1, 'Chrysler') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (2,1, 'Dodge') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (3,1, 'Jeep') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (4,2, 'Chevrolet') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (5,2, 'Buick') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (6,2, 'Cadillac') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (7,2, 'GMC') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (8,4, 'Toyota') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (9,6, 'Nissan') INTO tblBrand (BrandID, ManufactureID, BrandName) VALUES (10,6,'Infiniti') SELECT * FROM dual; -- populate the Model table INSERT ALL INTO tblModel (ModelID, BrandID, ModelName) VALUES (1,1, '200') INTO tblModel (ModelID, BrandID, ModelName) VALUES (2,1, '200 Convertible') INTO tblModel (ModelID, BrandID, ModelName) VALUES (3,1, '300') INTO tblModel (ModelID, BrandID, ModelName) VALUES (4,1, 'Town'||' & '||'Country') INTO tblModel (ModelID, BrandID, ModelName) VALUES (5,2, 'Durango') INTO tblModel (ModelID, BrandID, ModelName) VALUES (6,2, 'Avenger') INTO tblModel (ModelID, BrandID, ModelName) VALUES (7,2, 'Challenger') INTO tblModel (ModelID, BrandID, ModelName) VALUES (8,2, 'Charger') INTO tblModel (ModelID, BrandID, ModelName) VALUES (9,2, 'Caliber') INTO tblModel (ModelID, BrandID, ModelName) VALUES (10,2, 'Grand Caravan') INTO tblModel (ModelID, BrandID, ModelName) VALUES (11,2, 'Journey') INTO tblModel (ModelID, BrandID, ModelName) VALUES (12,4, 'Sonic') INTO tblModel (ModelID, BrandID, ModelName) VALUES (13,4, 'Cruze') INTO tblModel (ModelID, BrandID, ModelName) VALUES (14,4, 'Orlando') INTO tblModel (ModelID, BrandID, ModelName) VALUES (15,4, 'Colorado') INTO tblModel (ModelID, BrandID, ModelName) VALUES (16,4, 'Malibu') INTO tblModel (ModelID, BrandID, ModelName) VALUES (17,8, '4Runner') INTO tblModel (ModelID, BrandID, ModelName) VALUES (18,8, 'Prius') INTO tblModel (ModelID, BrandID, ModelName) VALUES (19,8, 'Camry') INTO tblModel (ModelID, BrandID, ModelName) VALUES (20,8, 'Corolla') INTO tblModel (ModelID, BrandID, ModelName) VALUES (21,9,'Rogue SL') INTO tblModel (ModelID, BrandID, ModelName) VALUES (22,9, 'Versa Note') INTO tblModel (ModelID, BrandID, ModelName) VALUES (23,9, 'Pathfinder') INTO tblModel (ModelID, BrandID, ModelName) VALUES (24,9, 'Altima') INTO tblModel (ModelID, BrandID, ModelName) VALUES (25,10, 'Q70') INTO tblModel (ModelID, BrandID, ModelName) VALUES (26,10, 'Q50') INTO tblModel (ModelID, BrandID, ModelName) VALUES (27,10, 'Q60') INTO tblModel (ModelID, BrandID, ModelName) VALUES (28,10, 'EX37') SELECT * FROM dual; -- populate Option table INSERT ALL INTO tblOption (OptionID,OptionDesc) VALUES (1,'Power locks') INTO tblOption (OptionID,OptionDesc) VALUES (2,'Power windows') INTO tblOption (OptionID,OptionDesc) VALUES (3,'Air conditioning') INTO tblOption (OptionID,OptionDesc) VALUES (4,'Heated mirrors') INTO tblOption (OptionID,OptionDesc) VALUES (5,'Remote keyless entry') INTO tblOption (OptionID,OptionDesc) VALUES (6,'CD Player') INTO tblOption (OptionID,OptionDesc) VALUES (7,'GPS') INTO tblOption (OptionID,OptionDesc) VALUES (8,'In-dash DVD player') INTO tblOption (OptionID,OptionDesc) VALUES (9,'Overhead DVD player') INTO tblOption (OptionID,OptionDesc) VALUES (10,'Satellite radio') INTO tblOption (OptionID,OptionDesc) VALUES (11,'MP3 player') INTO tblOption (OptionID,OptionDesc) VALUES (12,'Antilock braking system') INTO tblOption (OptionID,OptionDesc) VALUES (13,'Electronic stability system') INTO tblOption (OptionID,OptionDesc) VALUES (14,'Traction control') INTO tblOption (OptionID,OptionDesc) VALUES (15,'Cruise control') INTO tblOption (OptionID,OptionDesc) VALUES (16,'Intelligent cruise control') INTO tblOption (OptionID,OptionDesc) VALUES (17,'Parking assist system') INTO tblOption (OptionID,OptionDesc) VALUES (18,'Xenon headlights') INTO tblOption (OptionID,OptionDesc) VALUES (19,'Aluminum rims') INTO tblOption (OptionID,OptionDesc) VALUES (20,'AWD') INTO tblOption (OptionID,OptionDesc) VALUES (21,'Convertable') INTO tblOption (OptionID,OptionDesc) VALUES (22,'Heated Seats') SELECT * FROM dual; -- populate Vehicle table INSERT ALL INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (1,10, 2010, 45000, 18000) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (2,10, 2010, 65420, 17500) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (3,16, 2004, 143900, 3200) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (4,11, 2010, 38900, 14500) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (5,27,2014,17250,45999) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (6,25,2015,2900,62300) INTO tblVehicle (VehicleID,ModelID, VehicleYear, VehicleKM, VehiclePrice) VALUES (7,17,2010,87900,19800) SELECT * FROM dual; -- populate OptionDetail table INSERT ALL INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (5, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (7, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (8, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (11, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 2) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 1) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 3) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (6, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (11, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (12, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (14, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (15, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (19, 4) INTO tblOptionDetail (OptionID, VehicleID) VALUES (4,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (8,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (5,5) INTO tblOptionDetail (OptionID, VehicleID) VALUES (21,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (22,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (3,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2,6) INTO tblOptionDetail (OptionID, VehicleID) VALUES (1,7) INTO tblOptionDetail (OptionID, VehicleID) VALUES (4,7) INTO tblOptionDetail (OptionID, VehicleID) VALUES (5,7) INTO tblOptionDetail (OptionID, VehicleID) VALUES (2,7) SELECT * FROM dual; COMMIT;
原文:https://stackoverflow.com/questions/40139651
更新时间:2022-02-21 09:02
最满意答案
请用这个..
import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.os.Handler; public class Logo extends Activity { protected boolean _active = true; protected int _splashTime = 2000; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.logo); Handler handler = new Handler(); handler.postDelayed(new Runnable() { public void run() { finish(); Intent i3 = new Intent(Logo.this, Home.class); startActivity(i3); } }, _splashTime); } }
Please use this..
import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.os.Handler; public class Logo extends Activity { protected boolean _active = true; protected int _splashTime = 2000; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.logo); Handler handler = new Handler(); handler.postDelayed(new Runnable() { public void run() { finish(); Intent i3 = new Intent(Logo.this, Home.class); startActivity(i3); } }, _splashTime); } }
相关问答
更多-
下列中不属于面向对象的编程语言的是?[2022-05-30]
a -
Android无法启动活动(Android Unable to start activity)[2023-07-30]
你在TaskEdit.java:18中有一个NPE。 什么东西在那里? You are having a NPE in TaskEdit.java:18. What's there? -
将你的onCreate更改为: @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.mainlistview); list = (ListView)findViewById(R.id.list_listview); new DownloadFilesTask().execute(URL); ...
-
首先,您必须检查是否在manifest.xml文件中声明了所有活动。 并在您的Java代码中尝试这样: package com.example.flashlightapp; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.view.View; import android.view.View.OnClickListener; import and ...
-
这应该是这样的 public void onClick(View v){ 你需要在onClick(...)传递View作为参数onClick(...) This should be like public void onClick(View v){ You need to pass View as a Argument in onClick(...)
-
请用这个.. import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.os.Handler; public class Logo extends Activity { protected boolean _active = true; protected int _splashTime = 2000; /** Called when the activity ...
-
要在Android中启动新的活动,我需要使用意图吗?(To start a new activity in Android , do I need to use intents? [closed])[2023-12-16]
是。 开始活动的唯一方法是使用startActivity() (或startActivityForResult() ),并且每个都需要一个Intent 。 Yes. The only way to start an activity is to use startActivity() (or startActivityForResult()), and each takes an Intent. -
你的问题在这里解决了: 来自Google地图的NullPointerException 如果没有内置卡,请插入SD卡! Google自2013年以来不会解决这个问题。 Your problem is solved here: NullPointerException from Google maps Insert the SD card if you don't have an internal one! Google din't fix that problem since 2013.
-
改变这个 Intent counter = new Intent("com.example.test.Counter"); startActivity(counter); 这称为隐式意图,需要使用意图过滤器 至 Intent counter = new Intent(MainActivity.this,Counter.class); startActivity(counter); 这称为显式意图,不需要意图过滤器 你应该使用明确的意图当您在AndroidManifest.xml声明一个Activity时,声明一个这样的intent-filter :
相关文章
更多- Five More Hacker Tools Every CISO Should Understand
- spring 嵌套事务 的 加锁 问题
- solr join查询
- 怎么递归json嵌套json?
- 原来炒股可以这样理解
- EL 表达式 嵌套问题
- 深入理解Magento -前言
- Elasticsearch一些基础概念理解
- 理解Lucene/Solr的缓存
- 理解Hadoop的MapReduce
最新问答
更多- 获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
- 如何通过引用返回对象?(How is returning an object by reference possible?)
- 矩阵如何存储在内存中?(How are matrices stored in memory?)
- 每个请求的Java新会话?(Java New Session For Each Request?)
- css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
- 无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
- xcode语法颜色编码解释?(xcode syntax color coding explained?)
- 在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
- 从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
- 从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
- 西安哪有PLC可控制编程的培训
- 在Entity Framework中选择基类(Select base class in Entity Framework)
- 在Android中出现错误“数据集和渲染器应该不为null,并且应该具有相同数量的系列”(Error “Dataset and renderer should be not null and should have the same number of series” in Android)
- 电脑二级VF有什么用
- Datamapper Ruby如何添加Hook方法(Datamapper Ruby How to add Hook Method)
- 金华英语角.
- 手机软件如何制作
- 用于Android webview中图像保存的上下文菜单(Context Menu for Image Saving in an Android webview)
- 注意:未定义的偏移量:PHP(Notice: Undefined offset: PHP)
- 如何读R中的大数据集[复制](How to read large dataset in R [duplicate])
- Unity 5 Heighmap与地形宽度/地形长度的分辨率关系?(Unity 5 Heighmap Resolution relationship to terrain width / terrain length?)
- 如何通知PipedOutputStream线程写入最后一个字节的PipedInputStream线程?(How to notify PipedInputStream thread that PipedOutputStream thread has written last byte?)
- python的访问器方法有哪些
- DeviceNetworkInformation:哪个是哪个?(DeviceNetworkInformation: Which is which?)
- 在Ruby中对组合进行排序(Sorting a combination in Ruby)
- 网站开发的流程?
- 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
- 条带格式类型格式模式编号无法正常工作(Stripes format type format pattern number not working properly)
- 透明度错误IE11(Transparency bug IE11)
- linux的基本操作命令。。。