ThatJeffSmith

Tag: script

Formatting Columns in SQL Developer a la SQL*Plus

Does SQL developer support, col command that is used to format query results in sqlplus. like – col id heading app_id format a10 My answer was: ‘Yes.’ But I figured I should put up or shut-up a little bit, so here goes. You can read more about column formatting in SQL*Plus here (Docs). I used […]

Similar Posts by Subject Areas: , ,

SET PAUSE ON

This has been around for a loooooong time. But after a short chat with @oraclebase AKA Tim Hall yesterday, I thought I’d make sure we’re doing things right in the SQLDev tooling. Tim uses it to make very nice, short, and sweet video demonstrations on his YouTube Channel. I highly recommend it. Anyways, back to […]

Similar Posts by Subject Areas: , , , ,

A Quick 4.1 Trick: SET SQLFORMAT

One of your favorite SQL Developer ‘tricks’ is the ability to pre-format query output. So instead of getting standard output back, maybe you want query results to come back as CSV. But using that requires you to add code to your existing SQLs. Maybe instead it would be cool to set the overall script output […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer Meets SQL*Plus?

If you weren’t paying attention over the Christmas/Winter break, it’s very possible that you haven’t heard about our new project. You can find it on the SQL Developer version 4.1 Early Adopter download page.. If you’re not into reading so much, we have 7 or 8 blogs on the subject out there, you can just […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 20: See, Click, Goto Error Messages

This question comes up very frequently: Why can’t I see my compilation errors when I’m working with PL/SQL? Because you are either: using the wrong editor, or not asking to see the errors SQL Developer is the PL/SQL IDE for the database. So we obviously need to have those ‘fancy’ IDE features like a debugger, […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 13: Executing Very Large Scripts

What’s a very large script? That’s a subjective question, and the answer will depend somewhat on the hardware specs of your machine. I got this question yesterday: @thatjeffsmith is there a limit to the number of lines I can paste into the code editor in SQL developer? — louise mcscootash (@metalouise) September 12, 2014 I […]

Similar Posts by Subject Areas: , , ,

30 SQL Developer Tips in 30 Days, Day 8: Use the Cart to Build Deployment Scripts

Let’s say you have some objects you need to quickly create somewhere else. And you want to it such that it can be scripted/scheduled. I am using the Cart right now to build out a demo environment for folks that want to show off some SQL Developer features. For instance, I’m building a ‘shopping list’ […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 4: Statement Execution

A few quick things to remember: Try to always use statement delimiters Even before I go to execute this ‘statement’, SQL Devleoper is telling me I have a problem. The grammar check is failing. Notice those red squiggle lines? They actually mean something. So, add a semi-colon, or do this: Know the difference between executing […]

Similar Posts by Subject Areas: , , ,

SQL Developer Quick Tip: Running Scripts off the Web

Did you know you can run SQL*Plus type scripts directly from the web? Now, I’m going to assume the following: You know, trust, and have tested these scripts You don’t assume that everything on the Internet is true That Tim doesn’t think I’m trying to suck up to him, much So, in a SQL Worksheet, […]

Similar Posts by Subject Areas: ,

Clearing the Script Output Buffer in Oracle SQL Developer

Quick Question: Is there a way in SQL Developer to have the DBMS Output window clear when you execute a block? Quick Answer: CLEAR SCREEN [Oracle Docs] SQL Developer supports many, and soon to be ALL, SQL*Plus commands. CLEAR is one of them. So just add this to the top of your script. When you […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,