Search code examples
sqloracleoracle-sqldeveloper

Data from last Index tab in Oracle SQL Developer for JDBC

My Question is , is there a way to get all the Data displayd in the last tab "SQL" that is displayed in the Oracla SQL Developer. My purpose is to write a code that drops all tables and recreates them as they were.

enter image description here

Solution

  • My purpose is to write a code that drops all tables and recreates them as they were.

    If you are working with Oracle you can use the TRUNCATE TABLE, which just removes all the data from the tables. Here's a guide on how to use it.

    You do in essence like this ...

    TRUNCATE TABLE table_name
CASCADE;

    Does this solve your problem ?