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 - oracle10g

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

Sql Update query with self join on SCD2

I am facing an issue with SQL update query in with self join. I have looked into multiple pages here but didn't find the right solution. Suppose I have a table like below. id country city timestam...
test-img

Abhishek Shah

sql

oracle

oracle10g

Votes: 0

Answers: 2

Latest Answer

How about merge? SQL> select * from test order by id, timestamp desc nulls last; ID COUNTRY CITY TIMESTAMP ---------- ------- ------ ---------- 1 India Pune 222 --&...
test-img

Littlefoot

Oracle 10g Error: Warning: Trigger created with compilation errors

I have created database where I want autoincrement the primary key. I tried to trigger it but getting the above error here is my description of table: SQL> desc users Name ...
test-img

Krishna Dubey

sql

oracle

oracle10g

Votes: 0

Answers: 3

Latest Answer

There's nothing wrong with the trigger, as far as compilation is concerned (apart from the fact that you "forgot" to END it). SQL> CREATE OR REPLACE TRIGGER TR_USERS 2 BEFORE INSERT ...
test-img

Littlefoot

Posts

Questions

Blogs

Jobs