Create the endangered species table by running the following statement in Application Express

1. How many transactions are shown in the following code? Explain your reasoning.

BEGIN

INSERT INTO my_savings (account_id, amount)

VALUES (10377, 200);

INSERT INTO my_checking (account_id, amount)

VALUES (10378, 100);

END;

2

2. Create the endangered species table by running the following statement in Application Express:

CREATE TABLE endangered_species

(species_id NUMBER(4) CONSTRAINT es_spec_pk PRIMARY KEY, common_name VARCHAR2(30) CONSTRAINT es_com_name_nn NOT NULL, scientific_name VARCHAR2(30) CONSTRAINT es_sci_name_nn NOT NULL);

 

3. Examine the following block of code. If you were to run this block, what data do you think would be saved in the database?

BEGIN

INSERT INTO endangered_species

VALUES (100, ‘Polar Bear’, ‘Ursus maritimus’);

SAVEPOINT sp_100;

INSERT INTO endangered_species

VALUES (200, ‘Spotted Owl’, ‘Strix occidentalis’);

SAVEPOINT sp_200;

INSERT INTO endangered_species

VALUES (300, ‘Asiatic Black Bear’, ‘Ursus thibetanus’);

ROLLBACK TO sp_100;

COMMIT;

END;

 

 

 

3

4. Run the block above to test your theory. Confirm your projected data was added.

 

 

5. Examine the following block. If you were to run this block, what data do you think would be saved in the database? Run the block to test your theory.

.

BEGIN

INSERT INTO endangered_species

VALUES (400, ‘Blue Gound Beetle’, ‘Carabus intricatus’);

SAVEPOINT sp_400;

INSERT INTO endangered_species

VALUES (500, ‘Little Spotted Cat’, ‘Leopardus tigrinus’);

ROLLBACK;

INSERT INTO endangered_species

VALUES (600, ‘Veined Tongue-Fern’, ‘Elaphoglossum nervosum’);

ROLLBACK TO sp_400;

END;

find the cost of your paper

Complete independent research and review two (2) to three (3) online end-user license agreements.

Complete independent research and review two (2) to three (3) online end-user license agreements. Compare and contrast each EULA with each other. In your response, please consider the following: ·….

Write a SQL query that identifies the number of prescriptions grouped by drug name.

ALY6030 Final Project Assignment – Pharmacy Claims Due End of Week 6 Background: The excel file “ALY 6030 Final Project Data Set.xlsx” contains sample pharmacy claims for made-up members of….

Create a JavaFX program to allow a user to query the Northwind database.

Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program:   Print order total (not….