tag:blogger.com,1999:blog-2511956539743992936.post1215268628572652424..comments2024-03-16T12:46:41.382+05:30Comments on Satya's DBA Blog: Setting SQL prompt in SQL*Plus OracleSatya Thirumanihttp://www.blogger.com/profile/14440084623088726822noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2511956539743992936.post-37641260059374803422018-08-08T13:10:37.552+05:302018-08-08T13:10:37.552+05:30Really....It's a great effort from your side. ...Really....It's a great effort from your side. This will definately help all the freshers as well as experienced.<br />Thank You,<br />SatyaAnonymoushttps://www.blogger.com/profile/10187023196926644716noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-9796813846575554712013-03-14T15:23:35.543+05:302013-03-14T15:23:35.543+05:30Satya! Thank you very much . As a fresher iam lear...Satya! Thank you very much . As a fresher iam learning a lot from your blogAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-6331924292252833262013-01-07T16:43:09.616+05:302013-01-07T16:43:09.616+05:30Please read the Article.Please read the Article.Satya Thirumanihttps://www.blogger.com/profile/14440084623088726822noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-64342336744765684412013-01-07T16:30:43.827+05:302013-01-07T16:30:43.827+05:30how to change the sqlprompt name permanently.how to change the sqlprompt name permanently.Oracle DBAhttps://www.blogger.com/profile/11701360698974719438noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-48142000475864306702012-08-22T17:46:29.588+05:302012-08-22T17:46:29.588+05:30I've been setting my SQL Prompt in my login.sq...I've been setting my SQL Prompt in my login.sql for years.<br />I use Set SQLPrompt " _USER' @ '_CONNECT_IDENTIFIER > ";<br />and I get... JAMES @ My_DB ><br /><br />If I run any SQL commands, everything is fine.<br />However, if I run a script, my prompt changes to... _USER' @ '_CONNECT_IDENTIFIER > <br />and NOT... JAMES @ My_DB ><br />I hit enter, and it's back to... JAMES @ My_DB ><br />Why does it change, and how do I get it to remain... JAMES @ My_DB ><br /><br />Thank-You!<br />JamesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-73027787731170594542012-08-01T18:58:20.135+05:302012-08-01T18:58:20.135+05:30Hi,
The answer is already there in this SQL promp...Hi,<br /><br />The answer is already there in this SQL prompt article.<br /><br />To set SQL prompt permanently, update $ORACLE_HOME/sqlplus/admin/glogin.sql or login.sqlSatya Thirumanihttps://www.blogger.com/profile/14440084623088726822noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-57532710615659696522012-08-01T03:56:01.125+05:302012-08-01T03:56:01.125+05:30How can I make this sqlprompt as permanentHow can I make this sqlprompt as permanentAnonymousnoreply@blogger.com