Feed aggregator

Create table using existing table and copy column defaults

Tom Kyte - Thu, 2018-01-11 09:46
Hi Tom, I am creating table "tmp_pks1" with SID as DEFAULT 1. <code>SQL> CREATE TABLE tmp_pks1(SID NUMBER DEFAULT 1, NAME VARCHAR2(50) NOT NULL); Table created. SQL> CREATE TABLE tmp_pks2 AS SELECT * FROM tmp_pks1; Table created. SQ...
Categories: DBA Blogs

how to read clob data as varchar which has length morethan 4000

Tom Kyte - Thu, 2018-01-11 09:46
I have an XML data in Oracle with ClOB as Datatype. I have to read that clob data as Varchar. the following is the sample data. <code>"<POSLog> <Transaction> <UnitID>1101</UnitID> <WorkstationID>1</WorkstationID> <TransSequenceN...
Categories: DBA Blogs

Reference Partitioning in 11g

Tom Kyte - Thu, 2018-01-11 09:46
The new 11g Reference Partitioning option requires a foreign key on the child table, which requires a unique key on the parent table. To create a unique key on a partitioned table, you either need to include the partitioning key to get a local index...
Categories: DBA Blogs

Redacting the Number Column using DBMS_REDACT

Tom Kyte - Thu, 2018-01-11 09:46
I have redacted the Number Column of a Database Table.The column contains Check Number which is ten digits. The redaction on this Check Number column is partially masked with 0 for first three digits. When I query the column from the Database, it ...
Categories: DBA Blogs

How to Extract PL/SQL Source Code Diffs ignoring comments, spaces, linefeeds and alike

Tom Kyte - Thu, 2018-01-11 09:46
Hi : I need to compare all the PL/SQL source code (ie, Procedures, Functions, packages, and Triggers) between two databases (let's say, Homo and Prod) to get the diffs. Point is, I want to get only functional diffs, ie, only meaningful source cod...
Categories: DBA Blogs

oracle commit writes to redo, but not to datafiles

Tom Kyte - Thu, 2018-01-11 09:46
Hi Tom, I want to verify once the commit the transaction, only writes to redo log, but does not write to data files. How the verify the situation??
Categories: DBA Blogs

Drop an Oracle user (Schema) using JDBC java

Tom Kyte - Thu, 2018-01-11 09:46
Hi Tom; I am developing a java application using oracle as database. I connect to the database once per program execution using : try { pds = PoolDataSourceFactory.getPoolDataSource(); pds.setConnectionFactoryClassName("oracle.jdbc.pool.O...
Categories: DBA Blogs

SPM accepted plan with different bind variable

Tom Kyte - Thu, 2018-01-11 09:46
<code>Hi Tom, I have POC on my lab about SQL Plan Management and found some thing that not make sense. My Oracle Database Version is "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production" with a single node, parameter ...
Categories: DBA Blogs

Groupe Dynamite Deploys Oracle Retail Planning and Optimization Cloud Services

Oracle Press Releases - Thu, 2018-01-11 07:25
Press Release
Groupe Dynamite Deploys Oracle Retail Planning and Optimization Cloud Services Canadian Fast Fashion Retailer Propels Growth and Drives Inventory Productivity

Redwood Shores, Calif.—Jan 11, 2018

Today, Oracle announced that Group Dynamite deployed Oracle Retail Merchandise Financial Planning Cloud Service to propel teams forward with an integrated, science-based cloud planning solution. Groupe Dynamite operates more than 400 stores and online shopping experiences in 10 countries and employs more than 6,000 people with brands Garage and Dynamite.

As a fast fashion retailer, Groupe Dynamite delivers creative and fresh merchandising to drive customer engagement across multiple touch points. Groupe Dynamite required one unified global planning approach to drive inventory performance, the flexibility to configure the interface and the ability to infuse data science into assortment prioritization, all while supporting open-to-buy processes.

“Our current process and incumbent solution required an assortment planning process that was time consuming and cumbersome. By shifting to Oracle Retail, we are empowering our teams with an intuitive and modern interface, and a holistic planning solution that provides store level detail and allows us to make more strategic merchandise decisions” said Julie Fillion, Senior Director of Planning, Groupe Dynamite. 

“Currently we have a team of regional product intelligence professionals dedicated to analyzing data and identifying and transferring products into stores. With millions of items per year, we need to be more efficient with how we allocate time for products, especially in a highly competitive market.” said, Sylvain Duval, Chief Operating Officer, Groupe Dynamite. “We want to apply the science and optimization of Oracle Retail Cloud Services to drive efficiency and productivity today.” “The deployment of Oracle Retail Merchandising Financial Planning Cloud Service took three months and we stayed on time and on budget and look forward to the next phase to implement Oracle Retail Assortment Planning Cloud Service.”

Groupe Dynamite has a long-standing partnership with Oracle Retail. In 2011, Groupe Dynamite launched fast fashion women’s apparel retailer brands Garage and Dynamite in the U.S. supported by Oracle Commerce solutions. Underlying these applications is Oracle SOA Suite, which Groupe Dynamite is using to streamline real-time messaging processes. In 2014, Groupe Dynamite deployed Oracle Retail Merchandising, Stores and Financial Inventory Management solutions to accelerate international expansion with a single view of inventory.

“We are pleased to extend the partnership with Groupe Dynamite to the next step of their IT transformation. Our Oracle Retail Planning Cloud Services offer best-in-class solutions that enable retailers to drive profitability and remain flexible to the changing retail environment,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “With the minimized costs associated with cloud deployment retailers like Groupe Dynamite are able to experience return on investment more quickly.”

Oracle Retail at NRF 2018

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 14-16, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #3521. For more information check out: www.oracle.com/retail

Contact Info
Matt Torres
Oracle PR
+1.415.595.1584
matt.torres@oracle.com
Patty Oien
Blanc & Otus
+1.510.303.7289
patty.oien@blancandotus.com
About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries and territories while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

About Groupe Dynamite

Groupe Dynamite, a Montreal-based company with two brands at the heart of its success, operates more than 400 stores in Canada and worldwide and employs close to 6,000 people. The Company creates, designs, markets and distributes a constantly evolving edited fashion collection to a large network of Dynamite and Garage retail stores. The brand's core strength is rooted in a solid understanding of its customer and is a design-driven fashion retail organization. More information on Groupe Dynamite is available at www.dynamite.ca

Talk to a Press Contact

Matt Torres

  • +1.415.595.1584

Patty Oien

  • +1.510.303.7289

Behind The Scenes: Learn FREE Cloud & Identity Management with Me Live

Online Apps DBA - Thu, 2018-01-11 02:08

Hi If you are reading my mail first time in 2018 then Wish you a very Happy New Year. As I said in my last week’s mail (If you missed it then check your inbox on 4th or check on our Facebook Page http://k21academy.com/newsletter011), my Mission for 2018 is to have 100 Oracle Certified Cloud DBA’s […]

The post Behind The Scenes: Learn FREE Cloud & Identity Management with Me Live appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Get rows for first where condition

Tom Kyte - Wed, 2018-01-10 15:46
we face some issue as <code>select * from t where a is null or b is null or c is null</code> the question is if the query find the first where (a is null) then retrieve it only and not retrieve other where statment(b is null or c is null) can...
Categories: DBA Blogs

Very slow network interaction between Oracle DB and java application

Tom Kyte - Wed, 2018-01-10 15:46
I have a problem with my Oracle DB network speed. First of all, what's the essence of the problem. There are java application on my computer and Oracle DB on a remote server. Connection speed between them is about 2,5MB/s. I execute in my java app...
Categories: DBA Blogs

Update Statement with Duplicate Rows and Without

Tom Kyte - Wed, 2018-01-10 15:46
Hi, i created two table emp, emp2 from hr.employees. after that i executed below insert statements now in both tables employee_id is unique. <code>insert into emp select * from emp; --4 times insert into emp2 select * from emp2; --4 time...
Categories: DBA Blogs

Why we should segment advisor to get fragmented space for tablespaces where segment space management is AUTO

Tom Kyte - Wed, 2018-01-10 15:46
Hi AskTom Team, Normally, to get fragmentation we do (num_rows*avg_row_length) from dba_tables and compare that with bytes in dba_segments to see if there is any fragmentation. But for tablespaces with segment space management "AUTO" oracle re...
Categories: DBA Blogs

Split one string into multiple rows

Tom Kyte - Wed, 2018-01-10 15:46
Hi , I have a row that may contains upto 6000 char length string in a column. I want to check the length of string and then split the string into smaller string each of length 2000 and insert that into a second table. I want to do that in sql only. ...
Categories: DBA Blogs

Questions on DBMS_REDACT

Tom Kyte - Wed, 2018-01-10 15:46
Our applications works with ADF as UI and Oracle Database 12c in the Backend. As a regulation requirement,we have to mask few columns of the applications.The Entity Objects in the ADF are based on the Views. We have tried addressing these Col...
Categories: DBA Blogs

To Merge or Not to Merge (Instances) ??

Tom Kyte - Wed, 2018-01-10 15:46
Should we follow our Oracle DBA directive and merge our 5 instances into 1? That's the question!!?? A little background: Our Oracle EPM consultant installed our Oracle OBIEE and EPM apps (e.g. Hyperion Planning, HFM, DRM, FDMEE etc) using 5 ...
Categories: DBA Blogs

Identify free space gaps in a datafile

Tom Kyte - Wed, 2018-01-10 15:46
Oracle 11.2.0.4 12.1 and 12.2. You recently responded to a thread about reclaiming space.and suggested moving an object so it will not be at the end of a data file. https://asktom.oracle.com/pls/apex/f?p=100:11:33323285896587::NO::: Is the...
Categories: DBA Blogs

Using escape character --> ORA-01425

Tom Kyte - Wed, 2018-01-10 15:46
If I use the tilde to escape an underscore in SQL it works fine: select x from ( select 'A_Babc' x from dual union all select 'A$Bxyz' x from dual ) where x like 'A~_B%' escape '~' <b>X ------ A_Babc</b> However, when u...
Categories: DBA Blogs

"BEFORE EACH ROW" Trigger causes table locks without updating primary key column

Tom Kyte - Wed, 2018-01-10 15:46
Hi Tom, I've found a strange behaviour with our "BEFORE EACH ROW" triggers. In our database we have some tables that are refenrenced very often (50-80 references). All our tables have five common columns PK, CREATIONTIME, CREATIONUSER, UPDAT...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator