-- SELECT count(*) FROM EXT_TITEL_INFO
-- SELECT * FROM EXT_TITEL_INFO
set timing on

-- SELECT count(*) FROM EXT_BEDPBED;

-- PROMPT No Hashing allowed...
-- SELECT /*+ NO_USE_HASH(bedp t_info) */
-- bedp.BEDARFNR,
-- bedp.BEDP_SEQUENZ,
-- bedp.BEDP_TITELNR,
-- bedp.BEDP_MAN,
-- bedp.BEDP_MENGE_BEDARF_VM,
-- t_info.MELDENUMMER,
-- t_info.MENGE_VORMERKER
-- FROM EXT_BEDPBED bedp
-- LEFT JOIN EXT_TITEL_INFO t_info
--     ON bedp.BEDP_TITELNR = t_info.TI_NUMMER
--     AND bedp.BEDP_MAN = t_info.MANDFUEHR;
-- PROMPT ####################################

-- PROMPT All allowed
-- SELECT
-- bedp.BEDARFNR,
-- bedp.BEDP_SEQUENZ,
-- bedp.BEDP_TITELNR,
-- bedp.BEDP_MAN,
-- bedp.BEDP_MENGE_BEDARF_VM,
-- t_info.MELDENUMMER,
-- t_info.MENGE_VORMERKER
-- FROM EXT_BEDPBED bedp
-- LEFT JOIN EXT_TITEL_INFO t_info
--     ON bedp.BEDP_TITELNR = t_info.TI_NUMMER
--     AND bedp.BEDP_MAN = t_info.MANDFUEHR;
-- -- WHERE bedp.BEDP_MAN IN (1, 90) AND t_info.MELDENUMMER != 26;
-- PROMPT ######################################

-- SELECT * FROM EXT_TITEL_INFO t_info WHERE t_info.TI_NUMMER = 6132326;
-- SELECT * FROM EXT_TITEL_INFO t_info WHERE t_info.TI_NUMMER = 5641810;

-- SELECT t.TI_NUMMER, COUNT(*) cnt
-- FROM EXT_TITEL_INFO t
-- GROUP BY t.TI_NUMMER
-- HAVING COUNT(*) > 1;

-- SELECT 
--     (SELECT COUNT(*) FROM EXT_TITEL_INFO) AS total_rows,
--     (SELECT COUNT(DISTINCT TI_NUMMER) FROM EXT_TITEL_INFO) AS distinct_ids
-- FROM dual;

-- SELECT COUNT(*) 
-- FROM EXT_AUFPAUF auf 
-- WHERE auf.AUFTRAGS_DATUM > TO_DATE('2025-11-18', 'YYYY-MM-DD');

SELECT *
FROM EXT_AUFPAUF auf 
WHERE auf.AUFTRAGS_DATUM > TO_DATE('2025-11-18', 'YYYY-MM-DD');