Home » Developer & Programmer » Forms » copy records (oracle sql,10g,windowsXp)
copy records [message #392724] Thu, 19 March 2009 01:38 Go to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
hi all

I have two schemas in our database named as
1.employee
2.master
In employee schema i have one table.I want to copy the records from employee schema to master schema.

How can i achieve this?......

Thanks and regards

varosh

Re: copy records [message #392726 is a reply to message #392724] Thu, 19 March 2009 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
insert into target select * from source;

Regards
Michel
Re: copy records [message #392737 is a reply to message #392726] Thu, 19 March 2009 02:14 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
It works fine.
But i call the table in forms all the records show one by one.I gave particular id and click the pushbutton it display the error message like query caused no records in the data base.

How can achieve this?...

thanks and regards

varosh

[Updated on: Thu, 19 March 2009 02:16]

Report message to a moderator

Re: copy records [message #392743 is a reply to message #392737] Thu, 19 March 2009 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know Forms, I move the topic to this forum.

Regards
Michel
Re: copy records [message #392772 is a reply to message #392737] Thu, 19 March 2009 04:35 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You click a button ... which button? What does it do?

Oracle error messages are not "like" this and that. They have their codes and exact text.

Unless you provide more information, it is impossible to tell what's going on.
Re: copy records [message #392773 is a reply to message #392772] Thu, 19 March 2009 04:39 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
The coding of my push button is
execute_query(:myblock.id);


Thanks
Varosh
Re: copy records [message #392784 is a reply to message #392773] Thu, 19 March 2009 05:04 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Where did you find this syntax? Did you consult Forms Documentation?

And we still don't know the exact error code.
Re: copy records [message #392805 is a reply to message #392784] Thu, 19 March 2009 05:37 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
Hi !

I also tried with the following coding for that push button,

begin
select id,name into :stud.id,:stud.name from student
where id=:stud.id;
exception
when no_data_found then
message('Such Id doesnot exist');
end;


Iam getting the message
Such Id doesnot exist


when i didnt catch that exception, iam getting
Query caused no records to be retrieved


Thanks
varosh
Re: copy records [message #392818 is a reply to message #392724] Thu, 19 March 2009 06:19 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't replace execute_query with a select statement.
Just make execute_query work.
Using the correct syntax would be a good start - you can find it in the form builder help.
Re: copy records [message #394917 is a reply to message #392818] Mon, 30 March 2009 18:04 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: How to get Application server IP address
Next Topic: Need a Logic to check matching rows in the same table
Goto Forum:
  


Current Time: Sat Dec 10 14:35:00 CST 2016

Total time taken to generate the page: 0.08589 seconds