My Remarks!

the Life, the Universe and almost Everything what's Left

Total: 11 results found.

Search for:
Search Only:

1. How to copy data with "Long Raw" columns ...
(PL/SQL)
... to manage that with plain SQL. So here is a suitable workaround to solve this problem with a few lines of PL/SQL code   Starting point is a table with a long raw column: insert into long_table select ...
Created on 27 September 2015
2. String Tokenizer with Oracle PL/SQL ...
(PL/SQL)
This article describes how to tokenize a string, just with plain "out of the box" Oracle SQL. In the IT we often encounter requirements to split a string in parts. With Oracle PL/SQL we have a quit ...
Created on 08 December 2014
3. How to "Yes-No" in APEX - The Plugin
(APEX)
...  this kind of widget here is my new APEX plugin. This kind of widget will come "out of the box" with APEX 5.1 but if you will have it earlier, here it is!    To see how it works, visit my ITST ...
Created on 14 December 2016
4. How to handle Oracle BLOB columns via Database Link
(Oracle)
Oracle Developers are often faced with the problem to handle LOB data between several oracle instances via a database link. With plain SQL it is not allowed to select, insert or update a LOB on ...
Created on 05 October 2016
5. How to set manual locks to synchronize processes in Oracle
(PL/SQL)
...  l_lock_handle varchar2(128); begin -- first, get the lock-handle with the lock-name dbms_lock.allocate_unique(pi_lock_name, l_lock_handle); -- try to release the lock po_lock_result ...
Created on 18 November 2015
6. How to create a relation from Oracle to another physical database
(Oracle)
... d constraint test_view_dblink_pk primary key (column_name) disable; Last but not least: with this technique, we can create relations to all databases for which we have a oracle connector/gateway (e. ...
Created on 26 July 2015
7. How to Java programming in Oracle Database
(Java)
... Oracle version 8, it is possible to write Java code direct within the database. So it would be possible, to write stored procedures with Java instead of using PL/SQL. Nevertheless, the advantages of PL/SQL ...
Created on 07 December 2014
8. Downloads
(Uncategorised)
... lugin Slider.zip APEX Weather Plugin Weather.zip PL/SQL Package to generate a JSON string with GPS coordinates. itstar_apex_toolbox.zip      For the APEX Plugins, you  ...
Created on 01 November 2014
9. Oracle Goodies for XML and JSON
(PL/SQL)
... l information in the SQL statement. This is the perfect solution to present the data with all their dependencies like we are used to have it in a XML file. See the following example and the output we wi ...
Created on 27 September 2014
10. How to create an APEX Plugin
(APEX)
... described in this article. To see a Demo of the Plugin, click here!   Basics Since version 4.0 it is possible to extend the functionality of APEX with the so-called "Plugins". The plugin ...
Created on 13 September 2014
11. me
(Uncategorised)
... (B1) Education: Master Thesis and Research in Computer Science 1994/95 at Eastern Michigan University  Education in Computer Science with a Diplom (FH) Degree at the University of Applied Sciences ...
Created on 14 October 2012

Visits

Today 1259 | Week 6455 | Month 52726 | All 1440263

Donalds Daily Dumbs (The Guardian)

Donald Trump | The Guardian

22 July 2026

News about Donald Trump, the 45th and 47th US president, including comment and features from the Guardian

Latest Articles

Most Popular Articles last 24h

Most Popular Articles last Week

Popular Tags

Challenges Completed

Vätternsee Club des Cinglés du Mont-Ventoux Styrkeproven 24hVelo Belchen³ Guitar Rehearsal

StackOverflow

profile for PT_STAR at Stack Overflow, Q&A for professional and enthusiast programmers

(c) 2014 Stefan Armbruster