generated from dopt-python/py311
57 lines
1.6 KiB
SQL
57 lines
1.6 KiB
SQL
-- 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'); |