{"id":77908,"date":"2024-09-25T01:48:45","date_gmt":"2024-09-24T22:18:45","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/casedecodeif-else-2h5g\/"},"modified":"2024-09-25T01:48:45","modified_gmt":"2024-09-24T22:18:45","slug":"casedecodeif-else-2h5g","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/casedecodeif-else-2h5g\/","title":{"rendered":"\u0645\u0648\u0631\u062f | \u0631\u0645\u0632\u06af\u0634\u0627\u06cc\u06cc | IF ELSE – \u0645\u0646\u0637\u0642 \u0634\u0631\u0637\u06cc \u062f\u0631 PLSQL"},"content":{"rendered":"

Summarize this content to 400 words in Persian Lang <\/p>\n

1. \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0645\u0648\u0631\u062f<\/p>\n

\u062f\u0633\u062a\u0648\u0631 CASE \u0645\u0646\u0639\u0637\u0641 \u0627\u0633\u062a \u0648 \u0627\u0645\u06a9\u0627\u0646 \u0645\u0646\u0637\u0642 \u0634\u0631\u0637\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0634\u0631\u0627\u06cc\u0637 \u0686\u0646\u062f\u06af\u0627\u0646\u0647 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n

\u0646\u062d\u0648<\/p>\n

CASE
\n WHEN condition1 THEN result1
\n WHEN condition2 THEN result2
\n …
\n ELSE default_result
\nEND<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u0645\u062b\u0627\u0644 SQL<\/p>\n

SELECT employee_id,
\n first_name,
\n salary,
\n CASE
\n WHEN salary > 5000 THEN ‘High’
\n WHEN salary BETWEEN 3000 AND 5000 THEN ‘Medium’
\n ELSE ‘Low’
\n END AS salary_category
\nFROM employees;<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u062a\u0648\u0636\u06cc\u062d:<\/p>\n

\u0627\u06cc\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648 SQL \u0634\u0646\u0627\u0633\u0647\u060c first_name \u0648 \u062d\u0642\u0648\u0642 \u0648 \u062f\u0633\u062a\u0645\u0632\u062f \u0631\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u06a9\u0646\u0627\u0646 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc \u06a9\u0646\u062f.
\n\u0627\u06cc\u0646 \u062d\u0642\u0648\u0642 \u0631\u0627 \u0628\u0647 \u0633\u0647 \u062f\u0633\u062a\u0647 \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f: “\u0628\u0627\u0644\u0627” \u0628\u0631\u0627\u06cc \u062d\u0642\u0648\u0642 \u0628\u06cc\u0634 \u0627\u0632 5000\u060c “\u0645\u062a\u0648\u0633\u0637” \u0628\u0631\u0627\u06cc \u062d\u0642\u0648\u0642 \u0628\u06cc\u0646 3000 \u062a\u0627 5000 \u0648 “\u067e\u0627\u06cc\u06cc\u0646” \u0628\u0631\u0627\u06cc \u062d\u0642\u0648\u0642 \u0632\u06cc\u0631 3000.<\/p>\n

2. \u062a\u0627\u0628\u0639 \u0631\u0645\u0632\u06af\u0634\u0627\u06cc\u06cc<\/p>\n

\u062a\u0627\u0628\u0639 DECODE \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u062e\u0627\u0635 \u0627\u0648\u0631\u0627\u06a9\u0644 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0628\u0631\u0627\u0628\u0631\u06cc \u062f\u0631 \u0645\u0646\u0637\u0642 \u0634\u0631\u0637\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n

\u0646\u062d\u0648<\/p>\n

DECODE(expression, search1, result1, search2, result2, …, default_result)<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u0645\u062b\u0627\u0644 SQL<\/p>\n

SELECT employee_id,
\n first_name,
\n salary,
\n DECODE(salary,
\n 5000, ‘High’,
\n 3000, ‘Medium’,
\n ‘Low’) AS salary_category
\nFROM employees;<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u062a\u0648\u0636\u06cc\u062d:<\/p>\n

\u062f\u0631 \u0627\u06cc\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc SQL\u060c \u062a\u0627\u0628\u0639 DECODE \u0645\u0642\u062f\u0627\u0631 \u062d\u0642\u0648\u0642 \u0648 \u062f\u0633\u062a\u0645\u0632\u062f \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc \u06a9\u0646\u062f.
\n\u0627\u06af\u0631 \u062d\u0642\u0648\u0642 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 5000 \u0628\u0627\u0634\u062f\u060c “\u0628\u0627\u0644\u0627” \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u062f. \u0627\u06af\u0631 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 3000 \u0628\u0627\u0634\u062f\u060c “\u0645\u062a\u0648\u0633\u0637” \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f. \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a\u060c “Low” \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.
\n\u0627\u06cc\u0646 \u06cc\u06a9 \u0631\u0627\u0647 \u0633\u0627\u062f\u0647 \u062a\u0631 \u0628\u0631\u0627\u06cc \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u0634\u0631\u0627\u06cc\u0637 \u0647\u0646\u06af\u0627\u0645 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062e\u0627\u0635 \u0627\u0633\u062a.<\/p>\n

3. IF-THEN-ELSE (\u0628\u0644\u0648\u06a9 PL\/SQL)<\/p>\n

\u062f\u0633\u062a\u0648\u0631 IF-THEN-ELSE \u062f\u0631 \u0628\u0644\u0648\u06a9 \u0647\u0627\u06cc PL\/SQL \u0628\u0631\u0627\u06cc \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u0645\u0646\u0637\u0642 \u0634\u0631\u0637\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n

\u0646\u062d\u0648<\/p>\n

IF condition THEN
\n — statements
\nELSIF condition THEN
\n — statements
\nELSE
\n — statements
\nEND IF;<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u0645\u062b\u0627\u0644 PL\/SQL<\/p>\n

DECLARE
\n v_salary NUMBER := 4000; — Initializing a salary variable
\n v_category VARCHAR2(10); — Variable to hold the salary category
\nBEGIN
\n IF v_salary > 5000 THEN
\n v_category := ‘High’; — Set category to ‘High’
\n ELSIF v_salary BETWEEN 3000 AND 5000 THEN
\n v_category := ‘Medium’; — Set category to ‘Medium’
\n ELSE
\n v_category := ‘Low’; — Set category to ‘Low’
\n END IF;<\/p>\n

DBMS_OUTPUT.PUT_LINE(‘Salary Category: ‘ || v_category);
\n— Output the result
\nEND;<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u062a\u0648\u0636\u06cc\u062d:<\/p>\n

\u062f\u0631 \u0627\u06cc\u0646 \u0628\u0644\u0648\u06a9 PL\/SQL\u060c \u0645\u062a\u063a\u06cc\u0631 v_salary \u0628\u0627 \u0645\u0642\u062f\u0627\u0631 4000 \u0645\u0642\u062f\u0627\u0631 \u062f\u0647\u06cc \u0627\u0648\u0644\u06cc\u0647 \u0645\u06cc \u0634\u0648\u062f.
\n\u0639\u0628\u0627\u0631\u062a IF-THEN-ELSE \u0645\u0642\u062f\u0627\u0631 v_salary \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc \u06a9\u0646\u062f \u0648 \u062f\u0633\u062a\u0647 \u0645\u0646\u0627\u0633\u0628 \u0631\u0627 \u0628\u0647 v_category \u0627\u062e\u062a\u0635\u0627\u0635 \u0645\u06cc \u062f\u0647\u062f.
\n\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u062f\u0633\u062a\u0647 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DBMS_OUTPUT.PUT_LINE \u062e\u0631\u0648\u062c\u06cc \u0645\u06cc \u062f\u0647\u062f.<\/p>\n

\n
\n
\n

\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n