Łukasz Grala

#PLSQL #DATA #SQL #DEVELOPER #DB #DATABASE #SQLDEVELOPER PL/SQL - Paketlərdəki global dəyişənlər 👍 create or replace package global_degiskenler as     procedure main_procedure4; end global_degiskenler; / create or replace package body global_degiskenler as     v_max_category_id products.category_id%type;     TYPE order_id_collection IS TABLE OF NUMBER;     v_company_name customers.company_name%TYPE;        procedure  get_highest_stock_category is     v_max_category_id products.category_id%type;  begin     select category_id     INTO v_max_category_id     FROM products     WHERE unit_price * units_in_stock = (        SELECT MAX(unit_price * units_in_stock)        FROM products);     DBMS_OUTPUT.PUT_LINE('En yüksek stok değeri olan kategori id: ' || v_max_category_id);  end;       procedure get_top_orders   is     v_order_ids order_id_collection;  begin       v_order_ids := order_id_collection();     SELECT order_id BULK COLLECT INTO v_order_ids     FROM order_details     ORDER BY unit_price * quantity DESC     FETCH FIRST 3 ROWS ONLY;           FOR i IN 1..v_order_ids.COUNT LOOP       DBMS_OUTPUT.PUT_LINE('Sipariş ID: ' || v_order_ids(i));     END LOOP;  end;   procedure get_company_names is     v_company_name customers.company_name%TYPE;     v_order_ids order_id_collection;   begin      v_order_ids := order_id_collection();      SELECT order_id      BULK COLLECT INTO v_order_ids      FROM order_details      ORDER BY unit_price * quantity DESC      FETCH FIRST 3 ROWS ONLY;           FOR i IN 1..v_order_ids.COUNT LOOP        SELECT c.company_name        INTO v_company_name        FROM customers c        JOIN orders o ON c.customer_id = o.customer_id        WHERE o.order_id = v_order_ids(i);              DBMS_OUTPUT.PUT_LINE('Sipariş ID: ' || v_order_ids(i) || ' - Şirket: ' || v_company_name);     END LOOP;   end;       procedure main_procedure4 is   begin       get_highest_stock_category;       get_top_orders;       get_company_names;   end;         end global_degiskenler;

2

In PostgreSQL DB, HA Config, Match it! (3of5) #PostgreSQL #database #DBA #Oracle #SqlServer #mohankumars #DataSphere

1

Delve into Cross Joins in SQL Server with Steve Stedman's comprehensive tutorial. Get started here: https://lnkd.in/dpVfbJUB #SQLServer #TSQL #CrossJoin https://lnkd.in/dpVfbJUB

3

In PostgreSQL DB, 2 types Schemas created for permanent Tables are #PostgreSQL #Oracle #SqlServer #database #DBA #education #mohankumars #DataSphere

3

https://zurl.co/OBRt Understanding Index Selection Mechanics in PostgreSQL #PostgreSQL #DBA #PostgreSQLPerformance #SQLTips #PostgreSQLConsulting

10

https://zurl.co/Xhwa How do Bloom Indexes work in PostgreSQL? #PostgreSQL #DBA #SQL #DatabaseSystems #OLTP #OLAP #Data #MySQL #Cloud #DevOps

7

One of the several capabilities of #Fabric #DataPipeline is that you can ingest millions of records in a table from your on-prem #SQLServer to #AzureBlogStorage within few seconds! In upcoming video and article, I will demonstrate this data engineering process #DataEngineering

2

PostgreSQL 17 released . PostgreSQL was the first RDBMS to integrate JSON support. Please refer the new release updates for details. https://lnkd.in/gPDGsTBG #postgreSQL #JSON

1

1 komentarz