| How "copy from " SQL command working in forms [message #181241] |
Fri, 07 July 2006 10:59  |
vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai
|
Member |
|
|
hello
in our company we often need to copy one table /or insert few rows from one database server to another database server. For this i use this SQL command.
COPY FROM USER-NAME/PASSWORD@DATABASE-1 TO USER/PASSWORD@DATABASE-2 CREATE TABLE XYZ USING SELECT * FROM ABC.
my problem is ,this command not working in D2K(forms 5,6i), or in backend procedure. Is there any way to use this command to use through forms/ backend procedure so that we can avoid manual process.
What i want is " a way to create/insert/append one table from
server/database1 to another database/server." from front hand (via forms/backend procedure).
IS IT POSSIBLE??
i am using oracle 8i + d2k 6i
thanks
vikas gupta
|
|
|
|
|
|
| Re: How "copy from " SQL command working in forms [message #181316 is a reply to message #181245] |
Sat, 08 July 2006 10:18  |
vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai
|
Member |
|
|
hy maaher
it may be sql* plus or any thing it doesn't matter. i just want to ask ," a way to create a table from one database-server to another remote database server via front hand- D2k forms.
is it possible. (i give a example of copy command just bcoz by the use of that command it is possible via backend, not front hand)
vikas
|
|
|
|
| Re: How "copy from " SQL command working in forms [message #182359 is a reply to message #181316] |
Fri, 14 July 2006 08:06 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Use the dbms_sql package. Good examples can be found in "PL/SQL, Packages and Types Reference, 10g Release 1 (10.1), Part No. B10802-01 - search for it on the Oracle website by part number.
See page 90-11
Build a dynamic 'insert'.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
