Oracle Database

78K

Solutions

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Share tech news, updates, or what's on your mind.

Sign up to Post

HI

I have  a column that has a substring following 1st "_" and before 2nd "_" that I want parsed out.

1234567890123_ABCD_AN_XX_SRCV_A

1234567890123_ABCDE_AN_XX_FARB_B


So the  substring I want is ABCD and ABCDE (this can be any length)

The digits are always 13 at the start of the full string. And there are 5 "_" in the full string always.
0
Efficient way to get backups off site to Azure
LVL 1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Dear Experts,

I use Oracle Application Express 5.1.1.00.08.

I've created Interactive Report based on some heavy pl/sql query.

After submission, Report is generated and it consist of 50 pages.

Every time when I click on "next page" or trying to download generated report or or trying to sort columns, it takes too long and monitor sessions shows me that, source pl/sql query is executed again...

Is this normal or I've set something wring in settings?
0
I have a pl/sql  procedure this is the code:
PROCEDURE get_docClob(OFFSET IN NUMBER, opcDoc OUT VARCHAR2)
   IS
d VARCHAR2(5000);
BEGIN
    SELECT DBMS_LOB.substr( doc, 4000, OFFSET) INTO d
    FROM docClob
    WHERE ROWNUM <  2;
    opcDoc := d;
END ;  
I've tested it pl/sql developer with offset = 1 and doesn't return any thing and doesn't raise any errors.
I tested it in sql using this code:
SELECT DBMS_LOB.substr( doc, 4000,1)
FROM docClob
WHERE ROWNUM = 1;
and it returns the first 4000 characters of the clob.
0
How to reclaim space from BLOB tablespace - Oracle?   We deleted a bunch of assets and want to know if we can restore blob table space.
1
Hi All,
I need your help. I have the query below but I do not think is working as expected.

The business rule is that Date1 must be the earliest date, if not then show all records where Date1 is not the earliest. I started with this query but I think it needs some twitching to work, could you please help.
 

SELECT f.id_number,f.status,E.Date1,E.Date2,E.Date3,E.Date4,E.Date5,E.Date6
CASE
    WHEN E.Date1 > E.Date2      THEN 'Date2'           || ' ' ||  E.Date2
    WHEN E.Date1 < E.Date3      THEN 'Date3'            || ' ' ||  E.Date3
    WHEN E.Date1 < E.Date4      THEN 'Date4'             || ' ' ||  E.Date4
    WHEN E.Date1 < E.Date5      THEN 'Date5'           || ' ' ||  E.Date5
    WHEN E.Date1 < E.Date6      THEN 'Date6'       || ' ' ||  E.Date6
         END AS THE_DATE
FROM
       TableE E
LEFT JOIN TableF F
       ON F.id_number = E.id_number  
WHERE E.Date1  IS NOT NULL
0
In oracle have a stored procedure return a clob and in vb.net assign the clob to a devexpress richtextbox's rtftext property
0
Hi experts,
Could you please help. How to identify table row inserted or updated date & time using oracle way. E.g system column etc. and without using archive log or flash back files

Since this is a custom table and we don't maintain created or last updated column defined. So could you pls help

Oracle Database 11g
0
IN THE BLOCK PROPERTIES, DML Returning Value - I changed from NO to YES. I disabled the audit triggers in the database. Bit still when I delete a record,I get this error. What can be the reason?  I thought the database trigger is inserting a value. That is the reason I disabled the trigger. Help appreciated.
0
I want to store HTML code in database.
is it possible? If yes then how?
0
There is lot of code in the form and has many tabs. User is complaining of the slow process when they query the location and warehouse. I tried commenting much of the code that I thought is slowing down the execute query. Which is the right place or form trigger that I should first look i to?

Help is very much appreciated.
0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Table columns are Student ID, Student Name, Attendance(present/absent), Date
1001 john P 01-02-2017
1001 John p  02-02-2017
1001 john A  03-02-2017
1001 john A  04-02-2017
1001 john A  05-02 -2017------ for now highest consecutive absences is 3
1001 john p  06-02-2017
1001 john p   07 -02-2017
1001 john  A  08-02-2017
1001 john  A 09-02-2017
1001 john  A 10-02- 2017
1001 john A 11-02-2017
1001 john  A 12-02-2017
now it should be 5
0
I am installing Oracle 11g R2 64bit on Windows Server 2008 R2 64 bit but when I get to database creation screen, the installation hangs at 2%. I have tried the installation without database creation and installation was sucessful but when I try creating database with Database Configuration Assistsnt, it still hangs at 2%. I did that and left the server overnight but I still the max it went was 12%.
I need urgent help on this please.
0
I have two tables I want to update one column of the first table from the data from another column of the second table.how do I do?
0
What type of databases are supported by MySQL Workbench for data modelling (including forward engineering)?

For example, can I model and forward engineer to any of:
  • Oracle
  • SQL Server
  • PostgreSQL
  • Aurora
0
hi am geting this error when trying to start my pluggable database in 12c
SQL> alter pluggable database pdborcl open;
alter pluggable database pdborcl open
*
ERROR at line 1:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-65108: invalid use of a cursor belonging to another container


SQL> select name, open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBORCL                        MOUNTED
0
hi am in oracle 11g database am geting wrong value in connect prior check attachment
TABLESCRIPT.txt
0
CASE
             WHEN a.money = 1 THEN c.cashamount
             ELSE c.time
          END
             AS amount,
0
Can I have basic simple steps to install Oracle 11.g in Ubuntu 14.4
0
In an after update trigger I am getting bad bind variable error.
I am using two bind variable in the select statement as
Select field1, field2 from table1 t1 where t1.id = :new.id and t1.code = :new.code which is causing the error
Is there any alternate way to write this select in the trigger
0
NFR key for Veeam Agent for Linux
LVL 1
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Hi,

right  now need a study on any limitation on Oracle Golengate replication and MS SQL AOG for business case that need to setup 2 x site,  active active (not multi master). Then we try to POC on which one is better to use in terms of stability.

how about DB2's active active solution? any idea?

please present your idea.
0
i want to write a code as:
if(l_a<>nvl(l_b,l_c) and l_input<>k_input)
then
dbms_output.put_line('update required :' l_input)
elsif (l_input=k_input and l_a<>l_c)
then
dbms_output.put_line('update required :' l_input)
else
dbms_output.put_line('No update required')
end if
here all the variables are passed through cursor
can it be done?
0
Hi expert,

When i tried to join 6 table in my case shows diplicate  value .
please suggest if there is any other way to grt data.

Thanks in advance

Mihir
0
Hey Guys,
So i am basically clearing a form but want to control the fields that get clear on the form and then set the focus to a specific text box after.

I am able to clear the fields no problem but the setting of the focus on the text box is what i cant seem to figure out.

i tried go_item(:blockname, textboxname);
0
I started my oracle database but when i try to connect it gives this error please tell me how to solve this problem.

An error was encountered performing the requested operation: ORA-01033: ORACLE initialization or shutdown in progress 01033. 00000 - "ORACLE initialization or shutdown in progress" *Cause: An attempt was made to log on while Oracle is being started up or shutdown. *Action: Wait a few minutes. Then retry the operation. Vendor code 1033
0
Here is the SQL..

SELECT "C"."Value" "VENDORNAME","B"."DocumentGuid" "PROCESSEDDOC","B"."TOUCH" "TOUCHED"
FROM "HistoryOfField" C,
  (SELECT "A"."DocumentGuid",
    SUM(
    CASE
      WHEN "A"."Value" <> "A"."Value Previous"
      THEN '1'
    END) "TOUCH"
  FROM
    (SELECT "DocumentGuid",
      "FieldName",
      "Value",
      "Value Previous"
    FROM "HistoryOfField"
    WHERE "FieldName"  IN ('InvoiceNumber','InvoiceDate','Total','VendorID')
    AND "ReceivedTime" IN
      (SELECT MAX("ReceivedTime")
      FROM "HistoryOfField"
      WHERE "DocumentGuid" IN
        (SELECT "DocumentGuid"
        FROM "LastVersionOfDocument"
        WHERE "Exported"    =1
        AND "ReceivedTime" >= '08/03/2017 12:00:00 AM'
        )GROUP BY "DocumentGuid"
      )
    ) A
  GROUP BY "A"."DocumentGuid"
  ) B
WHERE "C"."DocumentGuid" = "B"."DocumentGuid"
AND "C"."FieldName"     IN ('APInvoiceType','InvoiceNumber','InvoiceDate','VendorID','Total')
GROUP BY "C"."Value","B"."DocumentGuid","B"."TOUCH"
0

Oracle Database

78K

Solutions

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.