AristaDBA's Oracle Blog....

An Oracle Blog Of A Learner....

sqlplus

Using HISTORY in SQL*PLUS 12.2….

March 9, 2017 by 1 Comment

One of the biggest things that we couldn’t do in the previous versions of the oracle database was to use the back arrow button-to reexecute the old commands, without typing them. Of course, a workarouns is possible in the form of rlwrap but it’s not comparable to a natively available feature in the SQL*PLUS. Well, … [Read more…]

Posted in: Fun Tagged: 122, 12c, sqlplus

Using PRELIM Option Of SQL*PLUS….

December 29, 2015 by Leave a Comment

A recent thread in the Database General Questions place was posted today. The original poster set some wrong values for the database memory related parameters and using those exceptionally large values, database got hung. Well, I don’t know whether that was the real issue or not as the original poster didn’t share the contents of … [Read more…]

Posted in: genernal Tagged: prelim, sqlplus

Case Used By My Query In Sql*Plus….

July 5, 2010 by 2 Comments

There was an interesting question which me and two other delegates were discussing in the last week’s session. One delegate asked that how can we make the queries fired use a particular case? I couldn’t recall any parameter which does so(any guesses?) . One solution which I proposed was to put all the queries in … [Read more…]

Posted in: Fun Tagged: sqlplus, trace
Aggregated by OraNA

AristaDBA|Google+ Page

February 2019
M T W T F S S
« May    
 123
45678910
11121314151617
18192021222324
25262728  

Recent Posts

  • SQL Goodies In Oracle 18c….
  • Test Post
  • I am speaking at Mumbai, OTNYatra 2007! Come and say Hi!
  • Using HISTORY in SQL*PLUS 12.2….

Tags

1z0-050 11g 12c ace advice aioug blog blog issues buffers Certification cloud dirty download em event Fun general Grid Console happynewyear ilm imu internal internals introduction library cache nic OCP OEL otn otnyathra ou packt private redo Public YUM rac rant Review sangam sociable sqlplus training twitter virtualbox virtual index wordpress

Recent Comments

  • The Oracle DBA Apps Girl on Using HISTORY in SQL*PLUS 12.2….
  • orana on VirtualBox 5.0.16 Released….
  • orana on Hello Noida-Are You Attending Oracle Cloud Day….
  • amar on Non-CDB Architecture Is Officially Deprecated….
  • oraclerp on Non-CDB Architecture Is Officially Deprecated….
  • mdinh235 on Non-CDB Architecture Is Officially Deprecated….
  • anandp86 on Non-CDB Architecture Is Officially Deprecated….
  • Anju Garg on Oracle 12c, ILM Management Part-1,In-Database Archiving….

Archives

  • May 2018 (1)
  • July 2017 (1)
  • June 2017 (1)
  • March 2017 (1)
  • October 2016 (1)
  • September 2016 (2)
  • March 2016 (3)
  • December 2015 (2)
  • January 2015 (2)
  • October 2014 (1)
  • August 2014 (1)
  • July 2014 (3)
  • June 2014 (2)
  • May 2014 (1)
  • April 2014 (3)
  • March 2014 (2)
  • February 2014 (1)
  • January 2014 (1)
  • November 2013 (1)
  • October 2013 (1)
  • September 2013 (2)
  • July 2013 (2)
  • June 2013 (4)
  • February 2013 (4)
  • January 2013 (1)
  • December 2012 (2)
  • November 2012 (3)
  • October 2012 (1)
  • September 2012 (1)
  • July 2012 (1)
  • June 2012 (2)
  • April 2012 (1)
  • March 2012 (2)
  • February 2012 (1)
  • December 2011 (3)
  • October 2011 (1)
  • September 2011 (1)
  • August 2011 (1)
  • July 2011 (2)
  • June 2011 (1)
  • April 2011 (3)
  • February 2011 (1)
  • January 2011 (1)
  • December 2010 (2)
  • October 2010 (1)
  • September 2010 (2)
  • July 2010 (4)
  • June 2010 (2)
  • May 2010 (2)
  • April 2010 (2)
  • March 2010 (4)
  • February 2010 (4)
  • January 2010 (2)
  • December 2009 (2)
  • October 2009 (2)
  • August 2009 (5)
  • July 2009 (3)
  • June 2009 (1)
  • April 2009 (2)
  • March 2009 (5)
  • February 2009 (5)

Visitor Location….

Locations of visitors to this page

Tripit….

Where I Am….

Console

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Copyright © 2019 AristaDBA's Oracle Blog.....

Omega WordPress Theme by ThemeHall