Someone asked about persisting table filters. Quick answer, we don’t. When you leave and come back to table, the filters are no longer active. Don’t know what I mean by filters? So, if you close the table and come back, the filter won’t be there anymore. MOSTLY. It is there, you just have to ask for it. Ctrl+Space. Now scroll …
Oracle SQL Developer: Display Structured Value In Grid
Dealing with a complex data type? Say, XML? Or, a nested table? If you want to see a ‘flat’ view of the data for that bit or a row when browsing a data set that contains that TYPE of data, you’ll want to check this preference. Using the code sample from OraFaq – thanks folks! – here’s what I mean. …
Showing TYPE’d Column Values in SQL Developer
Someone on the innerwebs asked how to show the data inside their user defined TYPE’d column in a table when querying it with SQL Developer. Here’s their code: CREATE OR REPLACE TYPE ANSCHRIFT_T AS OBJECT (STRASSE CHAR(12), HAUSNR CHAR(3)); CREATE TABLE VERTRETER(V_NR NUMBER(4) PRIMARY KEY, ANSCHRIFT ANSCHRIFT_T); INSERT INTO VERTRETER VALUES (1, ANSCHRIFT_T(’TESTWEG’,’14’)); INSERT INTO VERTRETER VALUES (2, …
Aligning Objects in your Data Modeler Diagrams
Kris (no, not THAT Kris) asks… Is there some sort of ruler that is built into this software? If not, is there some way to select a table and then specify X and Y coordinates so that I can top left align all of the diagrams that I’m creating. Currently, I am zooming in and switching between diagrams to top …
Infographic: Oracle SQL Developer Data Grid Features
There’s quite a few things you can accomplish by manipulating and tweaking our data grids in SQL Developer without having to write a single shred of SQL. I’m not going to flood you with 35 blog posts on the subject. But I’ll share a few that will give you an idea, and if you’re interested in the others, use the …
Trick: ‘Pasting’ SQL Developer Exports to an Outlook Message as an HTML Table
You have some data. You want to email it to someone. You don’t want them to have to open an attachment. You want it to be in an HTML-Tabl’ish delivery device. In SQL Developer, write your query. Export to HTML > File. Open Outlook. Start your message. Attach File Point to your HTML File DON’T CLICK ON THE INSERT BUTTON …
30 SQL Developer Tips in 30 Days, Day 18: NULLs
This post was almost NULL – I was deep in Power Point mode for Open World, and almost forgot to write today’s post! Also, another admission: I said back on Day 1 of this series, that I was planning on doing 5000 push-ups this month as well. Well, I gave up on that a few days ago. I’m still pushing …
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 only change how the data …
Oracle SQL Developer and Viewing User TYPE Data
A ‘quick’ question came in this morning: “Jeff, does SQL Developer show contents of Object type columns? I’m advised not…” I wanted to say ‘Yes’ and then just run away laughing maniacally, but I thought maybe I should put together a quick example instead. So here goes. And by the way, welcome to 2013 everyone 🙂 Creating a USER TYPE …
Copying & Pasting Rows Between Grids in SQL Developer
Apologies for slacking on the blogging front here lately. Still mentally hung over from Open World, and lots of things going on behind the scenes here in Oracle-land. Whilst (love that word) blogging is part of my job, it’s not the ONLY part of my job 🙂 So a super-quick and dirty ‘trick’ this morning. Copying Query Result Record as …
- Page 1 of 2
- 1
- 2