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 strongm 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: *
- Users: juniorplsql
- Order by date
-
cursor for loops to insert record into a table
Thank you and thanks for the weblink- juniorplsql
- Post #11
- Forum: Oracle: All versions
-
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..- juniorplsql
- Post #9
- Forum: Oracle: All versions
-
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...- juniorplsql
- Post #7
- Forum: Oracle: All versions
-
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.- juniorplsql
- Post #5
- Forum: Oracle: All versions
-
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...- juniorplsql
- Thread
- Replies: 10
- Forum: Oracle: All versions
