python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - oracle12c

How to leave in the selection only those values that match on one line?

There is a table that stores information about the card. id_card, card_number, card_value When a client issues a card, he has a choice: digital card or digital with plastic When issuing a digital car...
test-img

Manne

sql

oracle

oracle12c

Votes: 0

Answers: 2

Latest Answer

If 621, 622 can be in in the same field then: WHERE card_value NOT LIKE '%622% If they're separate rows, I'm going to make an assumption that there's a unique identifier for each client since there's ...
test-img

Edward Radcliffe

Oracle: Why dateStr and dateFmt using different date format can work well in Oracle TO_DATE( dateStr, dateFmt)?

Oracle version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Test: select TO_DATE('2022.02.21','YYYY-MM-DD') from dual; --- convert success select TO_DATE('20...
test-img

Guo

oracle

oracle12c

to-date

Votes: 0

Answers: 1

Latest Answer

Oracle will ignore punctuation characters: String-to-Date Conversion Rules The following additional formatting rules apply when converting string values to date values (unless you have used the FX or...
test-img

MT0

Oracle ARCXXXX.0001 files and how to clear them

I would like to know what these files are and how to clear them. They've been using up quite a bit of my disk space. ARC file I have tried using RMAN to try and clear but I will get this error: RMAN T...
test-img

Jack Day

oracle

backup

oracle12c

Votes: 0

Answers: 1

Latest Answer

If your current system is not critical - put it into NOARCHIVELOG MODE; $ sqlplus / as sysdba SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP MOUNT; SQL> ALTER DATABASE NOARCHIVELOG; SQL> ALTER DATA...
test-img

Duong

Select Only the Most Recent Row

I'm using a query to pull the valuation cost of projects. It works well, except sometimes it returns multiple rows for a valuation. How can I modify my query to get only the most recent record to avoi...
test-img

GTS Joe

sql

oracle

greatest-n-per-group

oracle12c

Votes: 0

Answers: 2

Latest Answer

You can do a group by on the valuation and select the max date like below SELECT to_char( BVALUATN.G3_CALC_VALUE, '$999,999,999,999,999' ) AS "Valuation", MAX(TO_CHAR( G6ACTION.G6_AC...
test-img

Shanaya

Posts

Questions

Blogs

Jobs