New answers tagged oracle-sql-developer
What you are experiencing is called caching. The database doesn't have to go to disk the 2nd time because it can either get the data from its own buffer cache, or the operating system/disk array can also provide the data faster from its own cache. In order to see whether Oracle fetched the data from disk, or used its cache you can enable autotrace in SQL ...
Look at these packages: DBMS_METADATA - get_ddl function DBMS_METADATA_DIFF DBMS_METADATA_UTIL
Right click on the table name in the left pane and select Table -> Generate Table API Hope this helps!!
Top 50 recent answers are included