Stored procedure to transfer data in Oracle SQL Developer

Tags:
Oracle
SQL
Stored Procedures
How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer?
stagging table (stagcoindesk) to (coindesk) target table.
Was thinking about this code:
CREATE PROCEDURE YourProcedure AS
TRUNCATE TABLE YourTable
 
INSERT INTO YourTable
SELECT *
FROM OtherDatabase.dbo.SourceTable
GO
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    The code you posted appears to be SQL Server code.

    Can you confirm that you want to do this on an Oracle database?
    84,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: