Below you'll find a list of all posts that have been tagged as “script”
You’re using ORDS. You’ve written some web services. Now you need to control the underlying PL/SQL source. How do I get the code out? There’s a few ways. 1. Use SQL Developer On the Module, mouse right click. 2. Use SQLcl The REST command will get what you want. If you want this in a file, just use the SPOOL …
A customer ‘ambushed me’ – how dare they!?! – at the conference today, needing help getting their scripts to work. So something like this: And the way the customer wants to run scripta.sql (which calls scriptb.sql) So, where is SQL Developer going to look for scriptA? And when it gets to the @child\scriptb.sql? We can call scripts.sql using @c:\users\jdsmith\desktop\parent\scriptA.sql But, …
When executing scripts in SQL Developer, the amount of output we display on the screen is LIMITED. By design, we only show you 5,000 records from any query, and we limit the amount of output in total for a single script execution to 10,010 rows. This is controlled here: I know what you’re thinking… Why? A few reasons, but practicality …
Many of you might not know that most of what you can do in SQcl, can also be done in SQL Developer version 4.2. In fact, it’s the same code that handles running statements/scripts in SQLcl as it is in SQL Developer’s SQL Worksheet. Assuming of course, that you use THIS button. There’s one large exception to this. TODAY: we …
When I make jokes about copying and pasting code from StackOverflow or Github, I’m not really joking. But in this case, it’s OK. Because, I’m copying and pasting code from OUR GitHub project, AND my boss wrote the code. A question came in, and it’s come in a few times, but here’s the most recent variant: @Rumtis no way – …
Oracle SQL Developer Command Line (SQLcl) is the full name for what we’ve been calling, SQLcl. Have you seen the video? It’s only 8 minutes and will catch you up on just what SQLcl is. Anyways, there’s a ‘new’ command called SCRIPT that I want to show you today. I say ‘new’ because we added this in October of 2015. …
In SQL Developer we have color coded connections. This was added, not because we like Christmas trees and all the pretty lights, but because sometimes you need a reminder of what database you’re on. So you don’t TRUNCATE stuff, accidentally. Visual cues won’t prevent all mistakes, but they sure help. With SQLcl, you have the abilty to setup your SQL …
You want the create script for a table. You want the create script for ALL of your tables. You want the tablespace. But not the constraints. How do you configure this in our tools? SQL Developer: The Preferences & the Wizards Go to the preferences. Database, utilities, export. SQLcl: SET DDL HELP SET DDL SET DDL And now run the …
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 those same queries as a …
This challenge has come up a few times recently for me. Just HOW can a SQL Developer user quickly build out a SQL script for a database user that will include ALL of their privileges, roles, and system grants? I didn’t have a good answer until today. A group of DBAs at a large shipping company exercised my brain just …