Up sqlplus query multiple SQL not line, how can let the output is the line, ensure that the content of the output is normal

CodePudding user response:

You can stick your results came out to see?

CodePudding user response:

Cut a figure, how do you guess this description?

CodePudding user response:

1, paste into the editor;
2, through the toad tools, such as have the function of organizing format,

CodePudding user response:

Solved by other means, Mr Into data, and then through the awk capture the output to a file, the last on the spell out execution can, that you have what method can let vc_sql output is the line at the beginning, direct execution, hope god can teach,,,

Finishing record the statement at the time, here convenient subsequent reference

CodePudding user response:

reference 4 floor weixin_42591031 response:

solved by other means, Mr Into data, and then through the awk capture the output to a file, the last on the spell out execution can, that you have what method can let vc_sql output is the line at the beginning, direct execution, hope god can teach,,,

Finishing record the statement at the time, here convenient subsequent reference

This way how can I look at you so tired? Don't bother?...

CodePudding user response:

Ranks of conversion, I need to do this is each field individually shows a line? Try unpivot

CodePudding user response:

reference 5 floor js14982 reply:

Quote: refer to 4th floor weixin_42591031 response:

Solved by other means, Mr Into data, and then through the awk capture the output to a file, the last on the spell out execution can, that you have what method can let vc_sql output is the line at the beginning, direct execution, hope god can teach,,,

Finishing record the statement at the time, here convenient subsequent reference

This way how can I look at you so tired? Don't bother? -- --

Format is more troublesome, always has a problem, can only output a line, a great god help to see what can be directly output on at a time,

CodePudding user response:

refer to 6th floor minsic78 response:

this is to do the ranks of transformation, each field individually shows a line? Try unpivot

To each of the insert statement as a line, multi-line output

CodePudding user response:

refer to the eighth floor weixin_42591031 response:

Quote: refer to the sixth floor minsic78 response:

Ranks of conversion, I need to do this is each field individually shows a line? Try unpivot

To each of the insert statement as a line, multi-line output

See how your script, see all don't should be a single output, how to get out of?

CodePudding user response:

Directly in the line up sqlplus execute the SQL see, cut a figure out about specific query result is what kind of format