Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. 7. use the substitution & method of insert com

7. Use the substitution & method of INSERT command to populate EMP_PROJ table. INSERT INTO EMP_PROJ...

70.2K

Verified Solution

Question

Programming

7. Use the substitution & method of INSERT command topopulate EMP_PROJ table. INSERT INTO EMP_PROJ VALUES (‘&empNo’,‘&projNo’, &hoursWorked); NOTE: enclose &empNo in ‘ ‘if the datatype is a string – VARCHAR2 or CHAR If empNo is NUMBERdatatype then do not enclose &empNo in ‘ ‘!

empNo

projNo

hoursWorked

1000

30

32.5

1000

50

7.5

2002

10

40.0

1444

20

20.0

1760

10

5.0

1760

20

10.0

1740

50

15.0

2060

40

12.0

Answer & Explanation Solved by verified expert
4.2 Ratings (814 Votes)
I have created an empty table of empproj assuming that theempNo is number10projNo is number and hoursWorked numberFor creating a table I have used the below commandcreate table EMPPROJ empNo number10    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

State the x-, y-, and z-intercepts for each of the following three planes: ...

Calculus
Q

Correct asnwer for 5 star rating. Suppose that you release a small ball from rest at...

Physics
Q

pls, I need Matlab code for, OFDM modulation (Matlab demo by at least 4 carriers)

Electrical Engineering
Q

Please show all steps and write neatly. Make sure the proving is with letters and not...

Advance Math
Q

Who should be vaccinated against HPV infection A Infants and young children B Teenagers between...

Biology
Q

A refrigerator has to transfer an average of 268 Joule of heat per second from...

Physics
Q

The speedometer of a car is designed to be accurate with tires that are 35...

Basic Math
Q

Assume you invest $10,000 today. How much will you have in four years...

Accounting
Q

2. Which inventory costing method assigns to Cost of Goods Sold the most recent purchases...

Accounting
Q

Presented here are the financial statements of Sarasota Company. Additional data: 1. Depreciation expense was...

Accounting
Q

Recording Fixed Asset Disposal On April 1, 2020, one of the two large production machines...

Accounting
Q

The ledger of Laurie Tour Service on March 31 of the current year includes the...

Accounting