PL SQL Tutorial : PL SQL Functions with examples || PL/SQL Tutorial for Beginners in Hindi

Подписаться 17 тыс.

Просмотров 15 тыс.

50% 1

A function is same as a procedure except that it returns a value.
We have discussed few examples of functions and different scenarios where functions can be used for our convenience.
Please like & share the video.
Subscribe the Channel to keep watching intresting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL S...
Learn DBMS & SQL : • SQL Tutorial for Begin...
SQL Interview Questions and answers: • sql interview question...
Java Interview Questions and Answers : • JAVA Programs for inte...
IT Career guidance: • Career Guidance
Interview Tips : • Interview Tips
IT Essentials and Tricks : • IT Essentials and Tricks
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview ...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Question...
Employee earning maximum salary in each department query : • SQL Query to find Empl...
How to delete duplicate rows from any table (2 different solutions): • SQL query to delete du...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth ...
Tricky SQL Queries Part1 : • SQL Tricky and Importa...
Basics of Database : • What is DBMS? Learn B...
SQL OPERATORS : • Operators in SQL || S...
AGGREGATE FUNCTION: • Aggregate function ||...
GROUP BY : • GROUP BY & HAVING || ...
Solve any Date related query : • How to Solve any SQL Q...
How to use Substring : • Substrings in SQL | L...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle ...
IT Jobs without Coding : • IT Jobs without coding...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Watch the complete sql and pl sql tutorial in Hindi to understand the necessary concepts of sql and plsql and to top any sql interview.

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 29

@prashantp9029 2 года назад

Hi the way you are explaining is tremendous......

@CodingGlitz 2 года назад

Thanks bhai😃

@chshabi3981 Год назад

SELECT * FROM HR.REGIONS CREATE OR REPLACE FUNCTION GetTotalEmployees return number is v_count := 0; begin select count (*) INTO v_count from hr.regions; return v_count; end; begin dbms_output.put_line(gettotalemployees()); end; i wrote similar code like your code sir but i get a error plz help me out error

@CodingGlitz Год назад

What is the error?

@vaibhavkore6240 Год назад

bhai ek no kya to sikhaya

@CodingGlitz Год назад

Thanks Bhai😊

@kanikasuneja7777 Месяц назад

jo 8:29 pe implement kia usi ko package bolte h?

@diptipandey485 8 месяцев назад

Hii sir, please make one project on sql queries

@shrutikshirsagar7094 4 месяца назад

Why you write procedure to print count of customer and salary why not you write a function 🤔

@CodingGlitz 4 месяца назад

It's not about printing, it is just to explain the concept and syntax using an example which can be understood by all.

@shrutikshirsagar7094 4 месяца назад

@@CodingGlitz I want to ask how to recognize when we can write procedure and when we can write function?

@CodingGlitz 4 месяца назад

Use functions when you want to perform some task which will be used multiple times. Think about reusability while using functions.

@bhagwatrandhave3192 Год назад

performance tunning pe bhi ek series bana dijiye sir please

@prashantp9029 2 года назад

Please explain some more examples Of functions and procedures

@bikashbarik4903 2 года назад

Pl make a vedio about plsql important program for interview.

@prashantp9029 2 года назад

Keep going

@chshabi3981 Год назад

get system get total employees invalid

@life_style819 Год назад

CRETE 1 TABLE COUNTRY_CODE AND COUNTRY_NAME INSERT SOME VALUE RETURN COUNTRY NAME WITH REF TO COUNTRY_CODE EG. IF INPUT IN THEN RETURN INDIA IF INPUT IS US THEN RERURN UNITED STATE OF AMERICA (INSERT FEW VALUES IN TABLE). How to write function for this question.

@CodingGlitz Год назад

You just need to write a simple query with where condition.

@life_style819 Год назад

@@CodingGlitz i know SQL query but i am not implementing that query in function. Can you tell me in function this question ❓

@CodingGlitz Год назад

What issue are you facing?

@CodingGlitz Год назад

Function is explained clearly in this video. If you follow this, then easily you will be able to write. If you don't start writing on your own you will never learn.

@nandiniacharya7050 Год назад

Thanks brother well explained..

@anandkumar-zf3ux 4 месяца назад

Thanks bro!!! Very well explained

@CodingGlitz 4 месяца назад

😊

@nd8223 2 года назад

Tsql PLSQL different hai kya

@CodingGlitz 2 года назад

TSQL is extension of SQL and is owned by Microsoft. Mostly the concept and everything will be same but few syntax might change. So if you are learning any SQL like in our case 'Oracle SQL' it is enough and only few syntax will change when you use other SQL like SQL server etc.