Tuesday Tip: Deleting from search results — Devonian Times

[![image-2](https://i2.wp.com/blog.devontechnologies.com/wp-content/uploads/2017/06/Screen-Shot-2017-06-13-at-6.01.03-PM.png)%5D(http://feedproxy.google.com/~r/devoniantimes/~3/gUJWl5P6Zdg/) > When using DEVONthinks search features, the results are handled a bit differently than browsing the database. The results are insulated from accidental deletion by default. So what if you want to delete something from the search results? Here are three options… Right\-click the file and choose Move All Instances to Trash from the ...

Creating a Table for Exchange With a Partitioned Table

[https://docs.oracle.com/database/122/VLDBG/maintenance-partition-tables-indexes.htm#GUID-2DE24EE4-00EB-4D58-A428-8E6CBD7E7F34](https://docs.oracle.com/database/122/VLDBG/maintenance-partition-tables-indexes.htm#GUID-2DE24EE4-00EB-4D58-A428-8E6CBD7E7F34)

E4 2017 is almost one month away!

E4 2017 is almost one month away! I am looking forward to three days of interesting talks. Register here.

Interesting Post by Jonathan Lewis

The opt_estimate hint is one of many that shouldn’t be used in end-user code and isn’t officially documented. Nevertheless – like so many other hints – it’s a hint that is hard to ignore when you see it floating around the code generated by the Oracle software. This note is prompted by a twitter question […] ...

Disable Mac OS X Gatekeeper

Ocassionally, there is a need to install an app created by a developer that is not identified by the security policy in place on the Firm's MacBook. Here is the short procedure I identified it works for me: in terminal type: sudo spctl --master-disable verify with: spctl --status open the application and quit it in terminal, type: sudo ...

Using @SQLcl (to be updated)

Taking the new command line tool @SQLcl for a first test drive.Plus Points- installation super-easy- a lot of commands interchangeable with SQL Developer- connectivity via TNS is easy to setup. TIP: if you do not have TNS_ADMIN environment variable in place, run show tnsin SQL Developer in order to get the location for the tnsnames.ora ...

Oracle Live SQL Tool

https://livesql.oracle.com/apex/f?p=590:1000:100225800561367

Oracle Extended Statistics

Introduced 11gR1 and based on virtual columns. Allows better selectivity.Condition has the be equality or IN-lists.We should use them when we have issues by an order of magnitude on the cardinality.Types: Column Group: Have to be from same table. Max 32 Expression: CBO does not know how an applied function impacts the cardinality of a ...

Oracle In-Memory Advisor

Oracle In-Memory Advisor availableFirst released in feb. 2015. Improved version released in July 2015: an updated version of the Database In-Memory Advisor is now available, more information My Oracle Support (MOS) note 1965343.1

SQL Developer Language Settings

Change Oracle SQL Developer language Occasionally, I have to work on Customer environments where the language is set to something non-ENGLISH. Here is how to quickly change that unwanted setting on SQL Developer setting: close SQL Developer edit the file sqldeveloper.conf found at location sqldeveloperbin by adding the option AddVMOption -Duser.language=en restart SQL Developer and ...

Browse Categories

%d bloggers like this: