If you need to start at index 1, use or WEEKDAY() + 1.
Example:
Source: https://stackoverflow.com/questions/1202919/mysql-dayofweek-my-week-begins-with-monday
Thursday, November 17, 2022
MySQL Day of week begin with Monday for DAYOFWEEK() alternative
Use WEEKDAY() instead of DAYOFWEEK(), it begins on Monday.
Thursday, May 12, 2022
How to check Oracle Table tablespace used
SELECT
OWNER, segment_name,segment_type,TABLESPACE_NAME, sum(bytes/1024/1024/1024) GB
from dba_segments
where SEGMENT_TYPE = 'TABLE'
AND TABLESPACE_NAME = 'CLAIM_DATA'
AND owner = 'CLAIM'
group by OWNER, segment_name,segment_type,TABLESPACE_NAME;
How to Check Oracle Database Tablespace
SELECT df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
ROUND(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) "% Free"
FROM
(SELECT tablespace_name,
ROUND(SUM(bytes) / 1048576) TotalSpace
FROM dba_data_files
GROUP BY tablespace_name
) df,
(SELECT ROUND(SUM(bytes)/(1024*1024)) totalusedspace,
tablespace_name
FROM dba_segments
GROUP BY tablespace_name
) tu
WHERE df.tablespace_name = tu.tablespace_name;
Subscribe to:
Posts
(
Atom
)
