Thoughts on Technology
You're new here, aren't you?
NetworkedBlogs allows you to stay up to date with blogs you love. Click the Follow button to follow updates from this blog.
NetworkedBlogs allows you to stay up to date with blogs you love. Click the Follow button to follow updates from this blog.
Information
| Blog Name: | Thoughts on Technology |
| Url: | http://akangtech.blogspot.com/ |
| Language: | English |
| Topics: | java, IT |
| Description: | stuff on technology. Feel free to critique |
| Popularity: | 1 Followers |
Blog Feed
How to disable and reenable constraints in Oracle
| Disable1. Run this script in your sql editor and output the resultsselect 'ALTER TABLE '||substr(c.table_name,1,35)|| ' DISABLE CONSTRAINT '||constraint_name||' CASCADE;'from user_constraints ...more |
Delete all rows in Oracle database
| 1. Run this:select 'delete from ', table_name, ' from user_tables;2. run and script the output into a file.3. copy paste the commands from the file into your SQL editor.done |
Oracle: Drop all tables in the present schema
| 1. Login as the desired user 2. Issue this SQL select 'drop table ', table_name, 'cascade constraints ;' from user_tables;3. You will then get a list of drop table commands.4. Just copy/paste into ...more |
Visit the
blog page on Facebook.
Authors:
Followers:
Displaying 1 followers.
Popular in:
Not enough data.
Calculated for blogs with 20+ followers.
Calculated for blogs with 20+ followers.
Related Blogs
Questions? contact: networkedblogs@ninua.com
Copyright (C) 2008, Ninua, Inc.