Questions about oracle-sqldeveloper
Read more about oracle-sqldeveloper
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)
Pull latest record in table with duplicate ID's
ID
DATE
col1
1
01-01-2022
apple
1
01-02-2022
orange
It's been a while since I've worked with sql (using oracle fyi). If I want to pull unique ID's with the latest Date (in this case only...
chicagobeast12
Votes: 0
Answers: 2
how to get DDL (create query of a table) of a table from SQL Developer
am using Spool in SQL Developer to get the Output into a CSV file.
where as i have heard of use of DDL command can b done to get the create query of a table.
my query is as below
spool "path/...
Salva
Votes: 0
Answers: 2
How to get the count of new unique ip address logged in to the website on each day using analytical function in sql?
Ex:
Date - up,
1/2 - 1.1.127.0 ,
1/3 - 1.1.127.1,
1/3 - 1.1.127.0,
1/4 - 1.1.127.3,
1/4 - 1.1.127.5,
1/5 - 1.1.127.3,
Output:
Date-count,
1/2 - 1,
1/3 - 1,
1/4 - 2,
1/5 -0
New and unique ip logge...
Sangram kishore Naik
Votes: 0
Answers: 2
Different behavior between Dbeaver and OSD clients with dates
I use Oracle Database 11g Release 11.2.0.4.0
When doing this query :
SELECT
CASE WHEN (DATE '2005-11-25') IN ('25/11/05') THEN
'TRUE'
ELSE
'FALSE'
END
FROM DUAL;
I get FA...
Samuel
Votes: 0
Answers: 2