Geek Answers Handbook

Question about oracle sql developer?

I created tables and views and entered some test data, but I want to know where I can get the sql code that I used to create and insert data, I tried to look in the sql history, but it is not thier, thanks :))

+4
source share
2 answers

You can get the SQL needed to create and populate the table:

1) To create a DDL table, go to the Tables node and select the table, then click the SQL tab and copy the DDL that it displays.

2) To insert DML, right-click the table name in the node tables and select "Export Data", then "Paste" ... and fill out the wizard. You can also create a DDL table to create this path, and not as I said in step 1.

+2
source

The F8 story should show you everything that happened on this tab in SQL Developer (for example, the xyz.sql file).
if you can’t find the story or ddl you want, you should be able to just get ddl by

select * from addmas where colA = 'my criteria' ;

and then click F9, then right-click on the grid and export the data to "insert" and this will create insert statutes for you (remember to insert the table name)

to get CREATE TABLE / VIEW (or an object, not change tables), you can right-click on the table name, select 'edit', then go to DDL (create). If you use this tool for your changes, it will also show you the ddl for change.

+1
source

More articles:


All Articles