oracle-sql-developer Image

oracle-sql-developer

question
red68 avatar image
red68 asked Default

Want to set control to be 10% of the treated population by segment/age/income without manually calculating it..there are alot of distributions. Do I use a cursor or best way to do this without manually running it? Thx.

oracle-sql-developer

0 Likes

0Answers

0 Comments

question
DEEPANSHU_KUNAL avatar image
DEEPANSHU_KUNAL asked Default

SQL ORACLE

oracle-sql-developer

0 Likes

0Answers

0 Comments

question
anthony.green avatar image
anthony.green answered Default

Oracle SQL to SQL server date range

oracle mssql oracle-sql-developer mssql2008

0 Likes

3Answers

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

How to remove extra period from a decimal value

oracle-sql-developer

0 Likes

1Answer

0 Comments

question
Rohi.98 avatar image
Rohi.98 asked Default

Update statement not working after 2 records in this trigger. Shows null value afterwards

oracle-sql-developer database-triggers

0 Likes

0Answers

0 Comments

question
Olutee360 avatar image
Olutee360 commented Default

Group by using values in a range

oracle oracle-sql-developer sql2014

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
MikeyBronowski avatar image
MikeyBronowski answered Default

I want to convert days to years, months and remaing days in oracle sql I have the number of days for example: 398 days, how to convert 398 days to number of years and number of months and remaining days like 398 days 1 year , 1 month and 2 days.

oracle-sql-developer

0 Likes

1Answer

0 Comments

question
ThomasRushton avatar image
ThomasRushton commented Default

Case Statement

oracle-sql-developer case-statement

0 Likes

0Answers

1 Comment

question
nathan714 avatar image
nathan714 asked Default

ORacle to SQL data type conversion for SYS.XMLTYPE STORAGE BINARY

migration oracle-sql-developer datatypes

0 Likes

0Answers

0 Comments

question
Kev Riley avatar image
Kev Riley answered Default

Count pairs in a consecutive order

sql-server-2012 oracle-sql-developer

0 Likes

1Answer

0 Comments

question
slamba89 avatar image
slamba89 published Default

Customers who purchased item just online, just in store and both.

sql oracle-sql-developer

0 Likes

0Answers

0 Comments

question
Oleg avatar image
Oleg commented Default

Hi All, I am looking for a method to calculate min, max and avg of customer spend each week in the last 90days by grouping it to bi-weekly data.

database oracle-sql-developer data-warehouse grouping

0 Likes

0Answers

1 Comment

question
lokeshlehkara avatar image
lokeshlehkara commented Default

I want to automate a report that has to be sent on daily basis

oracle-sql-developer help automation excel-connection send_db_mail

0 Likes

0Answers

1 Comment

question
Usman Butt avatar image
Usman Butt commented Default

I need a count of orders

sql oracle-sql-developer

This question has an accepted answer. Accepted

1 Like

1Answer

3 Comments

question
blackwidow avatar image
blackwidow commented Default

create a table

sql oracle-sql-developer

0 Likes

2Answers

0 Comments

46 Posts
39 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.