ThatJeffSmith

Tag: table

SQL Developer 4.1: Easier Excel Imports

The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer‘ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no […]

SQL Developer Video Tutorial: Split Those Grids

I’ve talked about how to make your really long sections of code easier to navigate by splitting your editors, but did you know we can make it easier to browse your tables and views too? No? Watch the movie then, you have 2 minutes to spare, yes? And seriously, don’t do the April Fool’s prank […]

SQL Developer Quick Tip: Reordering Columns

Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data? Don’t do that! Instead, just right-click on the column headers, select ‘Columns’, and reorder as desired. Then move up the columns you want to see first… This will […]

SQL Developer: I’m Looking at a Record, How Do I Edit It?

You’re doing some data clean-up, or maybe you’re just trying to answer a business question for a user, and you notice the data doesn’t look quite right. You want to click in that ‘(null)’ cell and tell the world that Tyler and Perry composed that song! But, we’re in a query result set, and not […]

How to Import from Excel to Oracle with SQL Developer

This question comes up about as frequently as the ‘how do I export data to XLS?’ question. It’s pretty simple once you’ve ran through the process a few times. But you may be here because you’ve never ran through the process before. This post will step you from beginning to end. You should be prepared […]

Oracle: Move Table to new Schema and Tablespace

A Toad user posed this question today: Is there a way to move a (marked) TABLE mytable123 from Tablespace AAA and Schema BBB to another Tablespace USERS and Schema MYSCH? Let’s tackle the 2nd and easiest part first! Moving a table or partition to a new tablespace is pretty straightforward: ALTER TABLE table_name MOVE TABLESPACE […]

He Ain’t Heavy, He’s My Table

Many of our Toad users need to work with really wide tables. By ‘wide’ I mean a table with many, many columns. Oracle currently supports a maximum of 1,000 columns for a table or view. If that includes you, then we can help you. Ok, maybe you don’t have a 1,000 columns, but I’m guessing […]