TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ramesh
NA
19
46.9k
how to insert the data in 2 tables in pl/sql stored procedure?
Aug 23 2012 12:52 AM
i have 2 tables table1, table2 . table1 columns are id,empname and table2 columns are id,empname, location.. so first insert the data in table1 based on table1 columns id, empname insert the data in table2.. that means table2 id,empname columns data must be same to table1 columns...if insert unmatched data it has to through error example
table1 table2
id empname id empname location
10 raju 10 raju hyd
20 kumar 20 kumar kerala
50 anil 50 anil TN
will no insert like that table2
id empname location
20 raju hyd
11 kumar kerala
here if try to enter that type of data it has to show error
i want script in pl/sql stored procedure
please help me urgent......
Reply
Answers (
5
)
How to write dynamic select stored Procedure
while execute the stored procedure it shows the following error?