Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. juniorplsql

    cursor for loops to insert record into a table

    Thank you and thanks for the weblink
  2. juniorplsql

    cursor for loops to insert record into a table

    Chris, thanks.... Since I am new to plsql i had one of those "hmmmm... i wonder can you do this in plsql moments"... if you know what I mean..
  3. juniorplsql

    cursor for loops to insert record into a table

    no I created a table and I wanted to write a plsql to insert data into that table. Just trying to some stuff but i think I got it to work. DECLARE v_emp_id employees.emp_id%TYPE := EMPLOYEES_SEQ.NEXTVAL; v_dept_id employees.dept_id%TYPE; v_first_name employees.first_name%TYPE; v_last_name...
  4. juniorplsql

    cursor for loops to insert record into a table

    There isn't any data in the table. I guess what I want to do is to see if I can write a plsql statement that will insert data into a table that I just created.
  5. juniorplsql

    cursor for loops to insert record into a table

    Hello i am fairly new to plsql and i am tring to create a cursor that inserts a record into my employees table This is the structure of my employees table: EMP_ID NOT NULL NUMBER DEPT_ID NOT NULL NUMBER FIRST_NAME VARCHAR2(30) LAST_NAME...

Part and Inventory Search

Back
Top