GOTO Statements in PLSQL | Oracle PLSQL tutorial in TAMIL

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

Просмотров 1,6 тыс.

50% 1

Oracle PLSQL tutorial in TAMIL | GOTO Statements | PLSQL tutorial for beginners in Tamil ‪@learncodetodaytamil‬.
Hello Guys welcome to Learn Code Today தமிழ் 👩‍💻
Give this video a Thumbs Up 👍
Share & Subscribe for More Videos😉
Click the bell icon to get notified for new videos 🔔
Feel free to drop your doubts in the comment section 📳
You can support me by buying a cup of coffee ☕ using the thanks button
Join this channel to get access to perks:
/ @learncodetodaytamil
If u have any queries, drop an email at blog.learncode@gmail.com 📧
In this video we have covered,
what is Goto statements, also explained with examples
Channel link: / @learncodetodaytamil
➤ Oracle PL/SQL Playlist:
• Oracle PL/SQL in Tamil
➤ Oracle SQL Playlist:
• Oracle SQL in Tamil
➤ Oracle SQL & PLSQL Interview & Practical Questions Playlist:
• Oracle SQL & PLSQL Int...
➤ Exceptions : • Exceptions in PLSQL | ...
➤ Procedures: • Procedures in PLSQL | ...
➤ Functions: • Functions in PLSQL | O...
➤ FOR Loop: • FOR LOOP in PLSQL | Or...
➤ IF Statements: • IF STATEMENT - CONTROL...
➤ CASE Statements: • CASE STATEMENT - CONTR...
➤ Collections: • COLLECTIONS - INTRODUC...
➤ Records: • RECORDS in PLSQL |COMP...
➤ %TYPE: • %TYPE in PLSQL | COMPL...
➤ % ROWTYPE: • %ROWTYPE in PLSQL |COM...
#oracleintamil
#oraclesqlintamil
#oracleplsqlintamil
#oracledatabaseintamil
#oracletamiltutorials
#plsqltutorialsintamil
#gotostatementsinoracle
#gotostatementinoraclesql
#howtousegotostatementsinoracle
#gotostatementsinoracleexample
#exitgotostatementsinoracle
#gotostatementsandforloopinoracle
#gotostatementsinplsqlblock
#gotostatementsoracleexample
#gotostatementsinplsqloracleexample
#gotostatementsconditioninoracle
#gotostatementsinplsqlexample
#howtolearncodingforbeginners
#howtolearncoding

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

12 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@krishnanselvam786 Год назад

thank you bro welcome back bro ......................

@yogeshs2470 Год назад

🎉 welcome bro, waiting for your pl/sql series

@story_cuts647 2 месяца назад

Thanks

@manjutharak Год назад

Hi bro please make Performance-tuning video it will help us from you

@learncodetodaytamil Год назад

We are planning to do series on this. Will let u know... Thanks

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

Sir plsql stub na enna , eppidi create pannanum nu sollunga. Adhu related edhachum other video irundha share pannunga reference kaga. Please.

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

Stubs means skeleton code or temporary code implementation... Where u will convey the idea or the logic to be used in the code (skeleton code or incomplete code) and needs further development. This one is used when ur team members are creating different components for this code. In such cases, stubs act as temporary replacements for modules or functions that are yet to be implemented. Let's say your team lead/manager giving a task to u and ur team mate to create a code. Your teammate is responsible for creating a functions and u are responsible for creating code.. Then ur team lead/manager ask u to provide the stub/skeleton code to know/check the structure and flow of the code u are implementing .. that time u should provide stub/skeleton code(incomplete code) CREATE OR REPLACE PROCEDURE process_status_prc (p_id NUMBER) AS v_status VARCHAR2(20); BEGIN v_status := calculate_status(); If v_status = 'Pending' THEN -- Additional logic for pending item status should be implemented here (yet to be implemented) DBMS_OUTPUT.PUT_LINE('Processing pending item'); ELSIF v_status = 'Shipped' THEN -- Additional logic for shipped item status should be implemented here (yet to be implemented) DBMS_OUTPUT.PUT_LINE('Processing shipped item'); ELSE DBMS_OUTPUT.PUT_LINE('item status unknown'); -- Additional logic for unknown order status should be implemented here (yet to be implemented) END IF; END; / CREATE OR REPLACE FUNCTION calculate_status RETURN varchar2 AS BEGIN -- Additional logic to calculate status should be implemented here (yet to be implemented) RETURN 'shipped'; -- Default until implementation END; / Here these two programs are called as stub or skeleton program or incomplete program...