↓
 

EvROCS

Completing the puzzle

EvROCS
  • Home
  • Evenementen
    • = Lijst van evenementen =
    • KScope
      • KScope Algemeen
      • KScope15, Hollywood Florida
      • KScope14, Seattle
      • KScope13, New Orleans
      • KScope12, San Antonio
    • Kerstmis 2013
    • OPP 2007
  • CV
  • Quotes
  • Contact
  • EScope
  • Downloads
    • Query KScope Sessies
  • Blog
Home→Tags JavaScript

Tagarchief: JavaScript

Being in command

EvROCS Geplaatst op 2020-08-19 door Erik van Roon2020-11-28

This post is the third one of three that together are an introduction to scripting in SQLcl.Also read part 1 and part 2. In the previous post I’ve created functionality for SQLcl that it doesn’t have “out of the box”.In this post I’ll continue to build on that script, but the information here is valid for any JavaScript script you develop for SQLcl. In short: I built some functionality in JavaScript that can read a client file and place the contents in a bindvariable.This script resides in a file called “file2bind.js” so we can use it by telling SQLcl we want to run a script with this name and certain parameter values.Executing that script is done using the built in command “script” As I’ve said a couple of times in that post: I’m lazy.So typing “script ” every time I want to execute this script will get on my nerves … Lees verder →

Geplaatst in SQLcl | Getagged Alias, Command, Custom, Custom Command, Extend, JavaScript, Listener, Scripting, SQLcl | Geef een reactie

A Person who won’t read has no advantage over one who can’t read

EvROCS Geplaatst op 2020-08-19 door Erik van Roon2020-08-23

This post is the second one of three that together are an introduction to scripting in SQLcl.Also read part 1 and part 3. The title of this blogpost is (supposedly) a quote from Mark Twain, and I completely agree with it.I was reminded of this quote when I was working on the subject of this blogpost. In SQL*Plus you can’t read the contents of a client file.Well, to be honest, you can do “get scriptname.sql” to place the contents of a SQL script in the execution buffer.Or you could copy the file you want to read to the server and use utl_file or an external table definition.But other than that, nothing.No way to just read the contents of any client file. Ok, SQL*Plus is limited, no news there.Let’s turn to the favorite command line tool of the 21st century, SQLcl. SQLcl is capable of reading client files and processing them. … Lees verder →

Geplaatst in SQLcl | Getagged bind, BindVariable, Client, File, JavaScript, Read, Read Client File, Scripting, SQLcl | 3 reacties

When great just isn’t good enough

EvROCS Geplaatst op 2020-08-19 door Erik van Roon2020-10-15

This post is the first one of three that together are an introduction to scripting in SQLcl.Also read part 2 and part 3. For many years now SQLcl is my favorite command line tool to connect to Oracle databases. (available at the bottom of the SQL Developer download page)It does (practically) everything SQL*Plus does and a whole lot more. It has many capabilities that SQL*Plus just doesn’t have.But this post is not about those goodies SQLcl delivers, it’s more or less about what is doesn’t…. No matter how good we think a tool is, and I think SQLcl is great, there will always be things missing, or not quite the way we would want them to be.SQLcl is no exception to this rule.Inevitably we run into something that makes us think “I wish it could do ….”.The team that brings us SQLcl (and SQL Developer and Datamodeler and ORDS) is … Lees verder →

Geplaatst in SQLcl | Getagged introduction, JavaScript, Scripting, SQLcl | Geef een reactie

Talen

  • nlNederlands
  • enEnglish (Engels)

Zoeken

Subscribe for notification of new blogposts

Subscribe to email notifications for new blog posts

 

Loading

RSS

  RSS Feed Blog Posts

  RSS Feed Comments

Recente berichten

  • Being in command
  • A Person who won’t read has no advantage over one who can’t read
  • When great just isn’t good enough

Follow me on Twitter

Erik van RoonFollow

Erik van Roon
Retweet on TwitterErik van Roon Retweeted
BayAreaPostgresBay Area Postgres@BayAreaPostgres·
ma 2021-03-01 18:06

Have you always wanted to speak at a conference but weren't sure if you'd be any good at it? Well, why not try it out with us by giving a talk at one of our virtual Meetups?

Send us a DM and let us know what you'd like to talk about!

evrocs_nlErik van Roon@evrocs_nl·
ma 2021-03-01 13:40

Always wanted to be a speaker?
Why don't you submit an abstract for #ConTech2021 ?
The only way to become a speaker is to have your abstracts selected.
And the first requirement for that to happen is that you submitted them.

Mirela@Mirela_RoOUG

📢
#ConTech2021 online, May, 25th + May, 26th, @RoOUG1
CfP is open until 31st of March.
https://bit.ly/3dXyW2c

Retweet on TwitterErik van Roon Retweeted
sqldailySQL Daily@sqldaily·
ma 2021-03-01 12:00

There are many ways of visualizing #SQL execution plans

But in huge plans they all struggle to help you spot the slowest parts

@TanelPoder has built a tool for turning Oracle plans into FlameGraphs to make this easier

https://tanelpoder.com/posts/visualizing-sql-plan-execution-time-with-flamegraphs/

Retweet on TwitterErik van Roon Retweeted
catalinmpitcatalins.tech/youtube@catalinmpit·
zo 2021-02-28 10:17

Every time I am in doubt whether to share content or not,

thinking that everyone knows what I want to show...

I am surprised to find that there are as many that didn’t know about it.

So, I guess, just share content, people! You never know who you’re helping! 🙏

Retweet on TwitterErik van Roon Retweeted
joelkallmanJoel R. Kallman@joelkallman·
vr 2021-02-26 21:12

Customer today: "I heard something about APEX being removed from the Oracle Database kernel" 🍿

My reply: "Not accurate. The only thing changing is how the @OracleAPEX installation software is being distributed with @OracleDatabase."

https://blogs.oracle.com/apex/on-premises-apex-installations-in-oracle-database-21c-and-beyond

#oracle #orclapex

Load More...
©2021 - EvROCS - Weaver Xtreme Theme
↑