Databases
StackOverflow2013
Postsdbo
POPL/SQL help. How to write a anonymous block that inserts 100 new rows
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPL/SQL help. How to write a anonymous block that inserts 100 new rows
    primarykey
    data
    text
    <p>I am new to PL/SQL (and programming in general) and been set a few tasks. I am working my way through them and getting on OKish but am stumped with this particular task. I using the Oracle Application Express and have created the table that I am working with which is called emp2</p> <p>Here is the task in it's entirety: Write a PL/SQL anonymous block that inserts 100 (new) employee IDs, starting at number 2000. Use a FOR loop, and declaration block for defining the lower/upper limits of the loop. In addition to the employee IDs, also add code that inserts placeholders in the first_name and last_name columns (avoid NULLs!), eg "FName_2000" and "LName_2000" for employee ID 2000. (Hint: Use the concatenation operator).</p> <p>This is the code that I have written so far (which I thought was spot on) minus the VALUES, as I just could not get this part to work?</p> <pre><code> DECLARE lower constant pls_integer := 2000; upper constant pls_integer := 2099; BEGIN FOR i in lower..upper LOOP INSERT INTO emp2 ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, HIRE_DATE, SALARY, DEPARTMENT_ID ) VALUES ( //UNSURE WHAT GOES HERE! ); DBMS_OUTPUT.PUT_LINE('Inserted' || SQL%ROWCOUNT || ' row'); END LOOP; END; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLuke Woodward
    1. USBob Bob
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPL/SQL help. How to write a anonymous block that inserts 100 new rows
      1. USBob Bob
      1. VTFavorite
    1. COWhen you say you could not get the `VALUES` part to work, have you tried a few things and not got them to work? If so, please edit your question to include what you've tried and the error messages you received.
      singulars
      1. POPL/SQL help. How to write a anonymous block that inserts 100 new rows
      1. USLuke Woodward
    2. COWell what I mean is that this is my first task where I have to use values. I 'know' that values is used here but don't how or what?
      singulars
      1. POPL/SQL help. How to write a anonymous block that inserts 100 new rows
      1. USBob Bob
    3. COThe `VALUES` section of an `INSERT` statement contains a comma-separated list of values to insert into each column. The first value in the `VALUES` section goes into the first column name in the `INSERT` statement (i.e. `EMPLOYEE_ID`), the second value goes into the `FIRST_NAME` column, and so on. Can you find values for each of the six columns, or are there any columns you're struggling with?
      singulars
      1. POPL/SQL help. How to write a anonymous block that inserts 100 new rows
      1. USLuke Woodward
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload