ThatJeffSmith

Tag: column

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? […]

Similar Posts by Subject Areas: , , ,

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. […]

Similar Posts by Subject Areas: , ,

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 […]

Similar Posts by Subject Areas: , , ,

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 […]

Similar Posts by Subject Areas: , , , ,

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 […]

Similar Posts by Subject Areas: , , , , , ,

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 […]

Similar Posts by Subject Areas: , , , ,

SQL Developer Formatter: Left Aligning Columns in a SELECT

Question: I can’t figure out how to make a column list align like this (underscore = space): _SELECT_column1 ______,_column2 ______,_column3 ______,_column4 ___FROM_table The closest result that the formatter produces is: _SELECT_column1, __column2, __column3, __column4 ___FROM table where all column names start at text position 3… My answer isn’t going to be perfect, but it’s going […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,