-
-
2. Re: Can the formatter be called externally?
thatJeffSmith-Oracle wrote:
Yes, see the format command in SQLcl.
I thought it was "sdcli" (SQL*Developer command line interface), not SQLcl.
What's the difference between the two?
EDIT
sdcli only has INPUT and OUTPUT options
sdcli format input=<input file or directory> output=<output file or directory>
With, SQLcl, you can change to formatting with
SET FORMAT RULES <filename>
(now -- if SQLcl had a method to run Unit Tests ... )
MK
-
3. Re: Can the formatter be called externally?
Excellent - I never considered that. I had to do it a bit of a long way around due to how my conversion script is running (write the SQL out to a temporary file, do a "sql.exe /nolog -S @do_conv.sql" where do_conv.sql basically just calls the formatter on the input/output files, and exits. But ultimately, it has done exactly what I want.
The only thing I couldn't get working was setting the rules xml file to be in a location which has spaces in the directory. Tried single and double quotes, neither seemed to work.
-
4. Re: Can the formatter be called externally?
Mike Kutz wrote:
I thought it was "sdcli" (SQL*Developer command line interface), not SQLcl.
What's the difference between the two?
Ah - so that looks like it might have been an easier solution because I can pass the names straight into that:
./sdcli64 format input=input.sql output=output.sql
-
5. Re: Can the formatter be called externally?
SQLcl is a smart SQL*Plus...it's an interactive CLI with access to SQL Developer features, including the formatter
sdcli is the entire SQL Developer program running as a 'headless' program. There's no prompt, it's just a program you can pass certain paramaters to for various operations. One of those is the formatter. It will take more time to run, but it's one and done type of requests.
sdcli will eventually go away and everything will be called via SQLcl
Right now SQLcl is more flexible with the formatter as well, I can't think of a reason to use sdcli over SQLcl for the formatter
-
6. Re: Can the formatter be called externally?
Can you call sqlcl with the format option as you can with sdcli, or do you have to "run" the format command from the tool (or redirect the command in stdin)?
-
7. Re: Can the formatter be called externally?
It's an interactive cli, so you'll go the <<eof route like you would with SQLPlus
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.