Below you'll find a list of all posts that have been tagged as “Excel”
So two areas of major performance improvements in Oracle SQL Developer version 18.2: Importing from Excel Using the Query Builder Importing from CSV was generally always pretty fast. Working with Excel consumes a lot of memory, and it took a lot of time to load an Excel file to be imported. Well, it still uses a lot of memory – …
It’s a bit long at 17 minutes, but I go through the process of: creating a new table based on an Excel/CSV defining the columns checking the column names checking the column definintions is the column wide enough? defining DATEs running the export fixing errors saving the scenario so you can run it on demand Remember, if you prefer to …
I’ve talked about the Cart a few times. It’s interesting to describe what the Cart is for, because it can be used or so many different things. But in general, it allows you do perform a set of operations against a collection of database objects. In this case I’m going to show you how to export several views and tables …
We love getting enhancement requests from our users. A good deal of the development in SQL Developer is guided by what our users are asking for. It does pain me a bit though when someone asks for a feature what we already have. Example: We frequently have a requirement to export working data (especially for data modeling purposes) to spreadsheets. …
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 matter how much money was …
In SQL Developer if you use the Import Data feature from the main tree node, it will create a new table based on a delimited text or Excel file. We’ll look at the data and create some columns for you. In version 4.1, we’ll recognize numbers as numbers, dates as dates, and try to get a best guess for you …
Oh, I so DO love hearing about things that ‘we cannot do.’ This morning I read that in an article that Oracle doesn’t allow you to copy data from Excel and paste directly to a table. AHEM. In the video you see me selecting the cells in the Oracle table editor before pasting the new ones in, but you don’t …
As you may have heard last week, we have a new version of Oracle SQL Developer Data Modeler now available as an Early Adopter release. Version 3.3 has quite a few new features and I’ll be previewing them here. Today’s topic is our new Excel integration. It builds off of last week’s lesson: Search, so you may want to go …
I’ve done a couple of posts on how to use SQL Developer to load your Excel files to an Oracle table. However, I always wonder how many folks realize there may be a ‘better way.’ If you are loading data to Oracle on a regular basis, there’s a few things I want you to know about: SQL*Loader Data Pump External …
In a previous post, How to Import from Excel to Oracle with SQL Developer, I covered step-by-step how to import data from Excel to an existing Oracle table. This post shows how to take a spreadsheet and transform it into a new table in your Oracle database. But first, please permit me just a few seconds as I step up …