Question: suppose we have a table: MASTER\_X\_Y in the database.

I want the syntax to run the query :

```
INSERT INTO MASTER_VARIABLE1_VARIABLE2 VALUES (.....);

```

where VARIABLE1 and VARIABLE2 have values X and Y respectively which have been selected from another table.

Is this possible ?  

( I have 38 possible combinations of X and Y and simply want to insert the selected data into the correct tables. Is there any other approach ? )

I am using oracle SQL 11g.  

This is the first time I am writing a PL/SQL procedure and I am not getting any straightforward answers.

Thank you !

Answer: 
Still need to test for the user hitting Cancel...This worked for me when hitting Cancel, or typing in 0, 1, or 11

```
Prints:
Dim NumberOfCopies As String
NumberOfCopies = Application.InputBox("How many copies do you want to print? Must enter 0-10", Type:=2)

If NumberOfCopies = "False" Or NumberOfCopies = "0" Then
  'If user hits Cancel, NumberofCopies will be "False"
Else
  If NumberOfCopies >= "11" Then
    MsgBox "Max to print is 10 copies"
    GoTo Prints
  Else
    ActiveSheet.PrintOut Copies:=NumberOfCopies
  End If
End If

```
Putting numbers in quotation marks turns them into a String. Since you want the user to input a number, you should make the following changes:

```
    Dim NumberOfCopies As Int
NumberOfCopies = Application.InputBox("How many copies do you want to print Must enter 0-10", Type:=1)

If NumberofCopies >= 11 Then
...

If NumberOfCopies = 0 or NumberOfCopies = "" Then
...

```