Delete the data from All tables in Oracle

In this case I need to delete all the Data in my tables because I'm making test of upload all the Data, and I'm too lazy to delete all the tables and create them again, so I'll show you a way to delete all the data :).
First you need to disable all the constraints, or at least foreign keys, if you don't do it, you can get an error unless you delete the tables in the right order. watch this post to disable them.

Disable and Enable All table constraints in Oracle

Now that you have disabled all the constraints, run the next pl/sql block that will delete all the data in all the tables. and as you don't have constraints, you will not get errors :D.
begin
for r in (select table_name from user_tables) LOOP
 execute immediate('delete '||r.table_name);
END LOOP;
end;
After do it, active again the constraints and it is done, you have deleted all the data from the tables, now you can celebrate that you have a clean data Base ready to test or first use :D. Now you can continue with your work and it will be great if you do it listening the below song ;).


Author

Comments

Post a Comment

Popular posts from this blog

View PDF File on APEX (Simple approach)

Image
PDF ( Portable Document Format ) is a popular file format to store digital documents, many applications require to upload PDF documents. Displaying the uploaded document in the same app could be useful for the user because he can review the PDF file without downloading it. I'll show you a simple approach to display the PDF file on an APEX application. This is simple, but it has a problem, it will use the Browser's PDF viewer, it could be not correctly configured on some users and it will not work on mobiles. However, I hope this be useful for you. This is the DEMO app where you can upload a PDF file and view it on the page, if this is not working, check your browser properties. This has been tested on Firefox 73 , Chrome 80, Opera 66, Safari 12 , Not working on Internet Explorer 11 or Edge. WARNING!!!! This will fail with Large PDF Files. If you need to work with large PDF Files, try Daniel's Approach in the Comments Section. PDF Viewer Demo APP If this is what you...
Read More »

Set Custom APP Icon on APEX

Image
I am creating my WorkSpace on  apex.oracle.com  to enable an online demo of my posts, then you can check if that is what you want before try it. Creating a new App, there are only 32 different Icons, but there are not Cat Icons. I wanted to add a Custom Icon, I'll explain how to do it. First, you need your icon on vector (.svg) format, you can create it using free tools like  Inkscape , Paid tools like  Illustrator , get it asking a Graphic Designer for help or Searching a free one on Internet. This time Chose the last one and got this  Cat Vector . You can find more on that site. Just remember, it is better if the vector has a squared aspect ratio Rename the .svg file to  app-icon.svg  and then go to  Your App -> Shared Components -> Static Application Files , upload the file and we got it!. our .sgv file is now our app icon and it will appear on APEX WorkSpace, Login Screen and Home Page. But you can notice that in ...
Read More »

Dynamic filter on Interactive Reports

Image
This feature will allow you to select a row on one Interactive Report and add a filter a second Interactive report using the selected value. This can be achieved easily with a Master Detail Page, APEX will use interactive grids for this, but if you want to use two interactive Reports or if your filter value doesn't come from a report, you can use the solution on this post. This is the demo app , if this is what you are looking for, keep reading the blog. For this example we'll use two interactive reports and one item to store the selected value. In this case we have the Department and Employee Reports, when the user clicks on one department, the employee report will be filtered by the department name. First, in the Department report, set the following properties on the column you want to use as link: Type: Link Target Type: URL URL: javascript:void(0); Link Text: <span class="name-filter"># DNAME #</span> Link attributes: d...
Read More »