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, …
Setting Default Script Execution Directory in SQLcl
We have a script execution directory setting in SQL Developer…but what about our new SQLcl command line utility? That was a question posed to me this morning. My answer was..well, let me show you my answer. ┌─[16:31:49]─[wvu1999]─[MacBook-Air-Smith]:~/sqlclNEW$ └─>cat login.sql SET sqlprompt "_user ‘@’ _connect_identifier >" SET sqlformat ansiconsole cd /Users/wvu1999/scripts ┌─[16:31:57]─[wvu1999]─[MacBook-Air-Smith]:~/sqlclNEW$ └─> Now you can see why: My prompt is …