Loading...

Follow svenweller – Notes about Oracle SQL, PLSQL an.. on Feedspot

Continue with Google
Continue with Facebook
or

Valid

Many developers don’t like select *. I’m a big fan of it, but there are some edge cases where one needs to be careful. I don’t want ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
#ThanksOGB This one goes out to the one I loveThis one goes out to the one I left behindA simple theme to occupy my timeThis one goes ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The following is a not complete and not ordered list of tiny and major features that I found interesting in the upcoming APEX 19.2 version ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Oracle sequences generate key values without gaps (minor exception from the rule: scalable sequences). Surrogate keys can and will have ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

TL;DR; -- increase INITRANS for the table alter table myTable initrans 4; -- Rebuild the table including indexes alter table myTable ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Introduction Edition based redefinition is a no extra cost feature of the oracle database. It allows to have multiple versions of the ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

After an upgrade to oracle database version 18.3 from 12.2 I encountered this error for a scheduled job of type EXTERNAL_SCRIPT. The job ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I rarely add extra APEX instrumentation code. In general I do instrument all my code, but usually I have plsql code that calls some ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Intro There are still a lot of misunderstandings about Oracle sequences. Sometimes even experts tell you things about sequences that are ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview