Sign in to vote Hello, we've recently migrated data from an oracle server to our sql server data warehouse, we have to have a way to check that all the data is the same between...
Pinning Objects At the top of every editor in SQL Developer, you’ll see a push pin button in the toolbar. Toggle that push pin to ‘Freeze Content.’ It doesn’t ‘freeze’ your table in the database, but it does force the table editor to persist even as you open anothe...
to find a list of user-created tables (thus ignoringsystem tables), we’ll need to find results where thextypecolumn (which specifies theobject typefor that row) is equal to the valueU, which stands for user table. The
So, we can easily find all the constraints on the table in Oracle using data dictionary views. We can then take whatever action like modify, disable, or drop, we want to take on these constraints. Constraints are enforcing data integrity rules in the Oracle database and we must be careful...
create table toys_clone as select * from toys;Easy, right?Yes. But, as always, there's more to it than this. You'll want to add some constraints to your table. And there are many types of table available in Oracle Database, including:Table...
What about table locks? Ah, good question. What if the table isn’t InnoDB, or what if someone locked it withLOCK TABLES, and it doesn’t show up in the output ofSHOW ENGINE INNODB STATUS? As far as I know, you’re helpless. I don’t know how to get any information on who’s...
Using the Oracle SQL Pivot statement, you can accomplish transposing multiple columns. The SQL syntax will be a bit more complex as you will need to use several aggregate functions in the pivot clause. Note that you will need to provide aliases for each function because, otherwise, the query...
I’ve always appreciated the CREATE OR REPLACE functionality in Oracle for views, packages and triggers, and I’ve often wanted a similar CREATE OR REPLACE TABLE. Many times, I’ll find myself needing to quickly drop and re-create a table while I’m designing it. ...
The first step in counting the rows in five minute groups is to find the interval they fall in. To do this, first assign the values into numbered buckets. This needs two key items: The origin datetime: the starting point for the time groups ...
Below are the steps to drop and recreate temp tablespace in Oracle. You can also assign default temporary tablespace to the newly created tablespace.