Oracle Magazine
Magazine
Published bimonthly (6-times per year) and distributed to more than 320,000 of the top IT managers, database administrators, and developers*, Oracle Magazine contains technology-strategy articles, sample code, tips, Oracle and partner news, and more. Source
Actions
Media Outlet details
| Scope | National, Trade/B2B |
|---|---|
| Language | English |
| Country | United States of America |
Similarweb UVM
|
Request pricing |
Comscore UVM
|
Request pricing |
| Frequency | Bimonthly |
Recent Articles
Search Articles
This site requires JavaScript to be enabled.
Dear Tom, One of my tables uses the clob datatype and has a total length of roughly 70000 characters. The data is truncating at 32767 characters when I'm spooling it to a.psv file, because of the set linesize 32767. I've used the following code.
Tablespace keeps autoextending to 30Gb
Have you checked the AUTOEXTEND properties for this data file? The database increases its size by whatever the NEXT value is - even if you only need a few extra megabytes.
Issue with JSON Transform
Hi Team, Any idea, why generic path expression based renaming of JSON fields does not work? A sample- 1. Below function transform top layer, but leaves nested layer. Select JSON_TRANSFORM('{"field_a": 2, "field_b": 3 , "nested" : {"nested1":{"field_a":2, "field_b":3 }}}', RENAME '$..field_a'='field_c') from DUAL; Output: {"field_b":3,"nested":{"nested1":{"field_a":2,"field_b":3}},"field_c":2} 2. While below can be alternate, but practically impossible with complex documents.
Oracle Becomes First Hyperscaler to Open a Cloud Region in Mexico
Oracle today announced the opening of the first Oracle Cloud Infrastructure (OCI) region in Mexico, becoming the first major cloud provider to establish a dedicated cloud region in the country. The new region in the state of Querétaro will give Oracle’s Mexico-based customers, partners, and developers access to a wide range of cloud services with built-in security, disaster recovery, and industry-leading price-performance.
Oracle CloudWorld 2022
Registration is now open Find education, innovation, and community at CloudWorld Join us at CloudWorld, the new global conference where our customers and partners can share ideas, develop in-demand skills, and learn about cloud infrastructure and applications solutions that serve their unique roles and business needs.
This site requires JavaScript to be enabled.
Querétaro Cloud Region
Regístrese ahora para ver este webinar a pedido. Subheading Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent id enim rhoncus justo pretium aliquam vitae at dui. Quisque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent id enim rhoncus justo pretium aliquam vitae at dui. Quisque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent id enim rhoncus justo pretium aliquam vitae at dui. Quisque.
This site requires JavaScript to be enabled.
This site requires JavaScript to be enabled.