python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - oracle11g

can someone tell me the equivalent postgres query of

Oracle SELECT distinct (i.index_name), decode(i.uniqueness,'UNIQUE','UNIQUE','') FROM all_indexes i, all_ind_partitions ip WHERE i.ow...
test-img

Biswajeet Sarkar

postgresql

oracle11g

Votes: 0

Answers: 0

ORA-00600 internal error code, arguments kcrfrgv_scn1

Actually my db got shut down when my pc powered of improperly due to cut of electricity. After that I started up the DB and My DB state has been changed to mounted I wanted to change it back to open m...
test-img

Arifullah

oracle11g

Votes: 0

Answers: 0

Parse JSON list with no key in PLSQL

What I'm trying to do is fill up a table with the data from a JSON. The file is formatted like this. [ { "name": "Victor", "age": "20" }, { &q...
test-img

Whiplax

json

oracle

oracle11g

oracle-apex

jsonparser

Votes: 0

Answers: 5

Latest Answer

--oracle 12c or later SELECT * FROM JSON_TABLE ( '[{"name":"Victor", "age":"20"},{"name":"Ana", "age":"23"}...
test-img

Abolfazl Aghili

Retrieve data more than once Oracle Query

This is my table: create table temp (acc number, name varchar2(20), mobile number); insert into temp (acc,name,mobile)values(123,'ABC',11111); insert into temp (acc,name,mobile)values(456,'ABC',11111)...
test-img

Bala S

sql

oracle

oracle11g

oracle10g

Votes: 0

Answers: 1

Latest Answer

Use the analytic COUNT function to find rows where there is are duplicate name/moblie pairs: SELECT acc, name, mobile FROM ( SELECT t.*, COUNT(*) OVER (PARTITION BY name, mobile) AS cnt ...
test-img

MT0

Posts

Questions

Blogs

Jobs