Skip to Main Content

Questions

QuestionUpdatedAsked

From the following table , I want to build a query using analytical functions to retrieve the rows where there is a common document type for a Customer ID but not the mix. The output should be only ROW_NO 3,4,5 & 9,10CREATE TABLE TAB_DOC_TYPES(ROW_NO NUMBER,CI...
27 hours ago6 weeks ago

I need function which convert numeric to alphabet like when I input 1 then it will return 'A', when i input 2 then it will return 'B' please help me on this....
44 hours ago4.3 years ago

How can I convince my developers there is a better way to do this?SELECT MAX (weight) weight FROM client.pet_weight WHERE pet_id = :pet_id AND setup_date = (SELECT MAX (setup_date) ...
44 hours ago21 years ago

Let's say we have a table of documents with key of doc_id. This table contains millions of documents(rows). There is also a table that assigns one or more industry codes to each doc:create table doc_ind( doc_id integer, ind_code varchar2(10))This ta...
44 hours ago22.6 years ago

Some Days before I have Install Oracle Database New version 12.1.0.2 with no error or warnings.Created 2 pluggable databases in the DB container. <code>SELECT name, open_mode from v$pdbs; NAME OPEN_MODE------------------------------ -...
44 hours ago7.7 years ago

We have many files available in our Linux mount point and wanted to load them into the table. The solution I'm seeking is to load all the files(with no-header, a different set of columns in each file, comma separated and new line char is available).<b>Sample f...
2 days ago2 weeks ago

We are writing to discuss an operational challenge that we are currently facing with the integration of Oracle Integration Cloud (OIC) and Oracle Autonomous Database within our organization. Our setup utilizes OIC as the primary integration layer, in conjuncti...
2 days ago2 weeks ago

Hi Connor/Chris,I am struggling to reason about the case attached in the liveSQL session.P1 spec ('get_field_value' just returns the value of 'field' from the record given)<code>CREATE OR REPLACE PACKAGE p1 AS field_default CONSTANT varchar2(4)...
2 days ago8 days ago

I encountered a problem related to forcing the refresh procedure on the materialized view in a combined manner: - refresh_method = 'F' - out_of_place = true<code>DBMS_MVIEW.REFRESH('FOO_MV', out_of_place => true, atomic_refresh => false, method => 'F');</code>...
2 days ago8 days ago

Hi,<b>There are several examples of hierarchal queries using the employees-manager example. Recently i came across hierarchal scenario where the table was storing multiple hierarchies. example data:</b><code>CREATE TABLE example ( Title VARCHAR2(50), ID ...
2 days ago9 days ago

Hello,We are start using EBR last year and sometimes we find some surprising behavior.Today I found that comments of editionable view are lost after view compile in a new edition. :-(Testcase:<code>alter session set edition=ORA$BASE;create user ebr_t1 default ...
2 days ago5 weeks ago

Hi,I want to create a stored procedure / function which will call shell script and shell script will have command to copy the file from particular location of DB server to another location of DB server.I tried using the scheduler job same is working fine but i...
5 days ago9 days ago

Hi Tom ,Not sure about category of this question but will explain the same We had come across one issue ..In pre staging server environment sequence column is generating incremented value as per the last record updated in a table via procedure (which is what ...
5 days ago9 days ago

Dear friends,I try to export csv from a patitoned table ( 300GB ) it takes 3 hours (only one table), using following code<code>set term offset feed offset colsep '|'set echo offset feedback offset linesize 1000set pagesize 0set trimspool onSET TERMOUT OFFspoo...
5 days ago8 days ago

Hi,I have a use case in which I want the end user to upload files from UI and it will directly store into the application's static files section. Are there any APIs available?Thanks,Tushar...
5 days ago8 days ago

I'm trying to use march_recognize() to find purchases made for each customer for 10+ consecutive days.A day being the next calendar date. For example, if customer 1 made 2 purchases on 10-MAY-2024 at 1300 hours and 1400 hours this would not be 2 consecutive da...
7 days ago8 days ago

<code>CREATE TABLE dept (dept_id NUMBER, dept_name VARCHAR2(50 CHAR), emp_count NUMBER);CREATE TABLE emp (emp_id NUMBER, emp_name VARCHAR2(50 CHAR), dept_id NUMBER);CREATE VIEW vw_dept_empcountASSELECT d.dept_id, d.dept_name, d.emp_count AS d_emp...
7 days ago2 weeks ago

I have a table like below.<code>create table t2 ( id varchar2(1),val number) ;insert into t2 values ('a',1);insert into t2 values ('a',2);insert into t2 values ('a',3);insert into t2 values ('a',4);insert into t2 values ('b',1);insert into t2 values ('b',2);in...
8 days ago4.9 years ago

I have been wondering for a long time why a select like "SELECT COUNT(*) INTO l_count FROM foo WHERE c_now >= ts + 1" in the following example issues a PLW-07204 warning but for example "SELECT COUNT(*) INTO l_count FROM foo WHERE ts < c_now - 1" does not.<cod...
8 days ago2 weeks ago

I have done a little searching, and not found anything that speaks to this, thought I would ask the experts:Recently I had to build an SQL script to be run in SQLPlus, and this script invoked another with the @ usage, and passed in a derived value as an argume...
9 days ago7.1 years ago