Some of you are real fast typers, and don’t need this type of help. However, some of you, no matter how fast you can type, have to deal with column names that are long, hard to spell, and to just work with in general. So let’s say you’re working on a report, and the column order is very specific. Now, …
7 Ways to Avoid SELECT * FROM Queries in SQL Developer
I said there were 8 ways to avoid using SELECT * FROM queries in SQL Developer – but I didn’t actually count them. So let’s do that now. @MarkusHohloch @tobias_arnhold there's about 8 ways to get columns to your query — OracleSQLDeveloper (@OracleSQLDev) November 23, 2016 But wait, what’s wrong with SELECT * FROM queries? you don’t need all the …
Data Modeler: Foreign Key Create New Column vs Use Existing
When using the data modeler, we assume when you add a foreign key, you haven’t already created the ID column. So we create that for you. Here’s what that looks like. I draw the relationship. I don’t want that. I want it to use USER.USER_ID instead. Click on the Column, and toggle it to USER_ID. When I click ‘Apply’ or …
SQLcl: ANSICONSOLE and Column Header Formatting
Question: Why is SQLcl truncating my column header names? It doesn’t do it if I use SET SQLFORMAT ANSICONSOLE though… Answer: Because, SQL*Plus. Longer Answer: SQLcl follows the SQL*Plus rules. And in this case, the rule is: The default width of CHAR and VARCHAR2 (VARCHAR) columns is the width of the column in the database. The questioner was seeing that …
Trick: Adding Columns to Query in the Desired Order
I tried to reference this post, and couldn’t find it. So apparently I have to write it now. I want to write a query. I want a bunch of column names. I could do this: But I’m very particular. Or maybe my customer is very particular. She wants SALARY then LAST NAME then FIRST NAME then EMPLOYEE ID. And so …
Modeling Virtual Columns
Virtual columns made their debut in Oracle Database 11g. They are a value that’s not stored with the row, rather they are computed as queried. [DOCS] So I could have a column of type DATE. And I could have a virtual column of type VARCHAR2 that is computed by running a function against the previously mentioned DATE column. How would …
Finding Columns
One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010. 2010. Wow, I says to myself – that’s gotta be interesting to a lot of folks, what is it? It’s a question on how to find table or view columns. And the ‘correct’ answer is to use …
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 …
Adding Common Columns to Tables via Templates and Transformation Scripts
In Oracle SQL Developer Data Modeler, you can create a table in your relational design that stores columns that you want to be added to all of your other tables. Call it, ‘table_template.’ Now call the transformation script. Tools > Design Rules & Transformations > Transformations. Before After These are cool, but they don’t belong in my Logical model! So …
SQL Developer 4.1: Multi-Cursor Editing
‘Make the editor work like Sublime Text or Crimson!’ So goes the several dozen requests I get each year. Well, in version 4.1, we’ve got something I think you’ll like. It’s a bit different than column text edit modes – but it allows for the same idea, and it’s even more powerful…I think. You can set the multi-cursor ‘hot key’ …
- Page 1 of 2
- 1
- 2