Blog

Ora-19025
  • 17
    Lug

Ora-19025

When you work with xml file you should be solve the scenery that have an node with its properly sub node. In our case the following nodes () ; () . It is quite delicate find exactly approach that gives to you the requirement expected. The problems that I have got they were two different: - Duplicate row...

Read More
Oracle Database 18c: My preferred new features for DBAs
  • 18
    Apr

Oracle Database 18c: My preferred new features for DBAs

Oracle Databse 18c comes with some cool new features for DBAs. In this article I'll list my preferred ones. Just one note: I think the name "Autonomous Database" is quite misleading, as it means that some of the new features COULD be used to configure your database as "autonomous" where previous versions required some maintenance, and this will...

Read More
Create Sequence-Oracle Database 12c
  • 1
    Mar

Create Sequence-Oracle Database 12c

Database version : from Oracle Database 12cR1 Create sequence with session or global option When a sequence number is generated, the sequence is incremented, independent of the transaction committing or rolling back. SESSION option makes opportunity to create sequence that can used in association with global temporary table then its visibility is just for session. The following options...

Read More
LIST-PARTITIONED
  • 7
    Feb

LIST-PARTITIONED

Introducing the topic: In list partitioning, the database uses a list of discrete values as the partition key for each partition. You can use list partitioning to control how individual rows map to specific partitions. By using lists, you can group and organize related sets of data when the key used to identify them is not conveniently ordered....

Read More