Making SQLPLUS Output Usable

1

Hi -
I’ve been dealing with a legacy Oracle DB and having issues getting connected directly into EM (other thread). However, I realized that I could write a .bat file to run sqlplus and output the file to a log/file. My issue now is that to parse that output may be even more problematic.

As an example:
@echo select * from GL.GL_CODE_COMBINATIONS; | sqlplus username/password@DB > C:\Users\arbeltz\output_fulldataset.txt

this would return ~1.5M Rows but SQL Plus does some interesting formatting that I can’t seem to get EasyMorph to read

As an example, just a rowcount looks like this on the output

image
image975×434 98.3 KB

But the data set would look more like this:

image
image975×736 191 KB

2

Hi Adam,

Can you attach a file with sample output? I will try to wrangle it in EasyMorph.

3

Can you try like

(@echo SET LINESIZE 32000; &@echo SET PAGESIZE 32000; & @echo select * from GL.GL_CODE_COMBINATIONS; ) | sqlplus username/password@DB > C:\Users\arbeltz\output_fulldataset.txt

and see how output looks like?

4

Thanks for the response. On my end I get an error when we add the brackets, if you take them away then the results are the same

image
image1787×287 20.6 KB

5

Hi @dgudkov -
I’ve attached a sample file with just name names and owners

SELECT owner, table_name FROM dba_tables;

04_Output_TableNames.txt (574.6 KB)

6

Hi @dgudkov - have you had an opportunity to see how this could be parsed in EM?

7

Not yet, this week I’m half-time off. I will have a chance to look at it next week.