My Oracle Support Banner

How to Export Table Data As Insert Statement in SQLcl (Doc ID 3056461.1)

Last updated on OCTOBER 30, 2024

Applies to:

Oracle SQL Developer - Version 19.2 and later
Oracle SQLcl - Version 21.2 and later
Information in this document applies to any platform.

Goal

 In order to export tables' data as insert statement sql files(1 file for each table) ,  Any command can export table data as insert statement in SQLcl?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.