- 1. How to handle Oracle BLOB columns via Database Link
- (Oracle)
- ... b where b.ID = a.ID ) AS BLOB_COLUMN FROM LOCAL_TABLE a; Solution 2: Pipelining Functions CREATE TYPE object_row_type AS OBJECT ( MYID NUMBER, MYCLOB CLOB ...
- Created on 05 October 2016
- 2. How to Java programming in Oracle Database
- (Java)
- ... STAMPLTZ java.sql.Timestamp ROWID, UROWID oracle.sql.ROWID oracle.sql.ROWID BOOLEAN boolean boolean CLOB oracle.sql.CLOB java.sq ...
- Created on 07 December 2014
- 3. Oracle Goodies for XML and JSON
- (PL/SQL)
- ... id = a.id ' || ' ) as phone_numbers ' || ' from ex01_person_tb a '; -- Create the XML aus SQL l_xml := itstar_xml_util.sql2xml(l_sql_string); -- Display the XML dbms_output.put_line(l_xml.getclobval()); end; ...
- Created on 27 September 2014
- 4. clob ...
- (Tags)
- clob ...
- Created on 06 October 2016
- 5. How to handle Oracle BLOB columns via Database Link
- (Article tagged with: clob)
- 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
Visits
Today 120 | Week 380 | Month 312 | All 1139323
Latest Articles
Most Popular Articles last 24h
Most Popular Articles last Week
Popular Tags
Challenges Completed
StackOverflow
