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 RUclips 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

[@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 ruclips.net/video/Mgf2wHtx0DQ/видео.html

[@arutce6573]

very useful!

[@HemantKChitale]

Glad you think so!

[@pritammorale1521]

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

[@HemantKChitale]

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

[@willyasyraf]

What linux version do you use, sir?

[@HemantKChitale]

Oracle Linux

[@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.

[@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.

[@srinivasp1231]

Unable to see the commands what u r executing.

[@HemantKChitale]

Slow down the video, pause it and watch it ?

[@EduFeastFamily]

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

[@HemantKChitale]

At %ORACLE_HOME%/sqlplus/admin

[@najmunnisanisar3316]

I know most of the queries.

[@HemantKChitale]

Good !