SQLPlus Formatting Commands

Using various formatting commands and options with the SQLPlus client -- whether you are using 12c or 11g or any older version

[@chibitori]

You're the best! Thank you! It was so hard to find a video that explained this.

[@HemantKChitale]

Glad it helped!

[@sauravsingh7216]

That's why CZcams is my first choice than google search!!!
Thanks for solution.....

[@HemantKChitale]

Thank you

[@rahullour7826]

very nice video sir i loved it thankyou

[@HemantKChitale]

You are welcome

[@arutce6573]

very useful!

[@HemantKChitale]

Glad you think so!

[@pravingaddam8541]

Very nice video bro. Here I want to mention that video is not clear but it's understandable.
Can you please help if my table contains 125 column and having row 10 lacks then which set parameters can I use to format results in CSV which looks proper in terminal

[@HemantKChitale]

Two options : sqlcl with the /* csv */ hint . OR sqplus with "set markup csv on". See this recent video czcams.com/video/Mgf2wHtx0DQ/video.html

[@willyasyraf]

What linux version do you use, sir?

[@HemantKChitale]

Oracle Linux

[@pritammorale1521]

how can i know my script filename while saving
format changes ????

[@HemantKChitale]

The script file name has nothing to do with presentation formats.

[@onkarmalawade171]

How you make row in code format

[@HemantKChitale]

What is "code format" ? INSERT statements ? You can extract rows as INSERT statements using SQL*Developer.

[@EduFeastFamily]

I'm using Windows. Where can I create my login.sql?

[@HemantKChitale]

At %ORACLE_HOME%/sqlplus/admin

[@dsun6792]

Sir I am not able to use the command to open script file can I get any another way

[@HemantKChitale]

Which "script file" do you mean ? login.sql is automatically executed by sqlplus.

[@najmunnisanisar3316]

I know most of the queries.

[@HemantKChitale]

Good !

[@srinivasp1231]

Unable to see the commands what u r executing.

[@HemantKChitale]

Slow down the video, pause it and watch it ?