Discussion :

[Lolitaaa]

BOnjour,
j'aimerais bien savoir sur TOAD comment faire pour générer du code SQL à partir des enreistrements existants dans une table donnée.

[c.langlet]

click droit sur la table + choisir export data

[fatsora]

dans TOAD

dans onglet TABLES

4 e bouton a partir de la gauche (EXPORT DATA AS INSERT STATEMENT)

Sinon par l'aide de TOAD

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
Create Insert Statements
Within the Schema Browser|Tables|Data Grid, you can create an INSERT statement that encompasses all rows in the data grid, or just selected rows. 
 
To create INSERT statements for selected rows
 
Right-click over the data grid and make sure that Multi-select is checked. 
 
In the data grid, select the rows for which you want insert statements.
 
Right-click and select Create INSERT for selected rows. The Data Export window appears. Make any changes to the settings and click OK. 
 
By default, insert statements are copied to the clipboard and you then can paste them within the Editor for editing or running. However, click the options tab and you can specify a destination.
 
To create INSERT statements for all rows
 
Right-click over the data grid and make sure that Allow Multi-select is unchecked. 
 
Right-click over the data grid and select Create INSERT for all rows. The Data Export window appears. Make any changes to the settings and click OK. 
 
By default, insert statements are copied to the clipboard and you then can paste them within the Editor for editing or running. However, click the options tab and you can specify a destination.