PL11- PL/SQL Tutorial - IF statements in PL/SQL (Theory)
Loading...
Loading...
16:50
PL13 - PL/SQL Tutorial - CASE Statement in PL/SQL (Theory)by oraclecoach4,704 views- 7:36
PL9 - PL/SQL Tutorial - DML and TCL statements (Theory)by oraclecoach5,195 views
- 11:21
PL15 - PL/SQL Tutorial - LOOP..END LOOP statement (Theory)by oraclecoach4,264 views
- 7:21
PL18 - PL/SQL Tutorial - While Loop Statement (Hands-On)by oraclecoach3,388 views
- 11:14
PL16- PL/SQL Tutorial - Loop Statement (Hands-On)by oraclecoach4,623 views
- 8:33
PL19- PL/SQL Tutorial - For LOOP construct (Theory)by oraclecoach3,699 views
- 8:31
PL24 - PL/SQL Tutorial - Explicit Cursors (Hands-on)by oraclecoach3,694 views
- 14:07
PL23 - PLSQL Tutorial - Explicit cursors in PL/SQL blocks (Theory)by oraclecoach4,671 views
- 8:12
PL7- PL/SQL Tutorial - SELECT statements in PL/SQL blocks (Theory)by oraclecoach7,126 views
- 15:08
PL14 - PL/SQL Tutorial - CASE Statement in PL/SQL (Hands-On)by oraclecoach4,062 views
- 14 videosOracle Tutorials - Developer Series
- 8:23
PL22 - PL/SQL Tutorial - Implicit Cursors (Hands-On)by oraclecoach2,874 views
- 10:28
V37 - Oracle SQL Tutorial - Joining Tables (Hands-on) - Part 1by oraclecoach10,151 views
- 7:28
A7 - Oracle SQL Tutorial - Managing Roles (Theory)by oraclecoach5,687 views
- 13:26
V15 - Oracle SQL Tutorial - Insert data into a tableby oraclecoach8,671 views
- 8:36
A1 - Oracle SQL Tutorial - Creating a User (Theory)by oraclecoach10,219 views
- 8:43
V26 - Oracle SQL Tutorial - Querying Data - Part 9 - Intro to Single-Row Functionsby oraclecoach5,364 views
- 13:42
V33 - Oracle SQL Tutorial - Querying a table - Part 11a) - Group Functions (Theory)by oraclecoach4,661 views
- 2:46
V17 - Oracle SQL Tutorial - Deleting data in a tableby oraclecoach3,742 views
- 14:58
V39 - Oracle SQL Tutorial - Joining Tables - SQL-1999 syntax (Theory)by oraclecoach6,054 views
Best Explantion actually better the institute where i had studied before
Thanks so much and waiting 4 more
MrLastgoodman 2 weeks ago
VSALARY HR.EMPLOYEES.SALARY%TYPE; - WHAT DOES THIS WAY OF DECLARATION MEAN?
IT DIDN'T WORK IN MY CASE.
THANKS FOR AN ANSWER!
EmarcelCom 2 months ago
Very explanatory!
TheChhoti 3 months ago
DECLARE
VSALARY HR.EMPLOYEES.SALARY%TYPE;
BEGIN SELECT SALARY INTO VSALARY FROM HR.EMPLOYEES WHERE FIRST_NAME='Lex';
IF VSALARY > 6000 THEN DBMS_OUTPUT.PUT_LINE('Earns more than Tom'); ELSE DBMS_OUTPUT.PUT_LINE('Earns less than Tom'); END IF;
END;
/
luisrhdzr 5 months ago
DECLARE VSALARY EMPLOYEES.SALARY%TYPE;
BEGIN SELECT SALARY INTO VSALARY FROM EMPLOYEES WHERE FIRST_NAME='SID'; IF VSALARY > 6000 THEN DBMS_OUTOUT.PUT_LINE('Earns more than Tom'); ELSE DBMS_OUTOUT.PUT_LINE('Earns less than Tom'); END IF;
END;
/
ORABEN 6 months ago