Posts

Showing posts with the label plsql

Featured Post

Python: Built-in Functions vs. For & If Loops – 5 Programs Explained

Image
Python’s built-in functions make coding fast and efficient. But understanding how they work under the hood is crucial to mastering Python. This post shows five Python tasks, each implemented in two ways: Using built-in functions Using for loops and if statements ✅ 1. Sum of a List ✅ Using Built-in Function: numbers = [ 10 , 20 , 30 , 40 ] total = sum (numbers) print ( "Sum:" , total) 🔁 Using For Loop: numbers = [ 10 , 20 , 30 , 40 ] total = 0 for num in numbers: total += num print ( "Sum:" , total) ✅ 2. Find Maximum Value ✅ Using Built-in Function: values = [ 3 , 18 , 7 , 24 , 11 ] maximum = max (values) print ( "Max:" , maximum) 🔁 Using For and If: values = [ 3 , 18 , 7 , 24 , 11 ] maximum = values[ 0 ] for val in values: if val > maximum: maximum = val print ( "Max:" , maximum) ✅ 3. Count Vowels in a String ✅ Using Built-ins: text = "hello world" vowel_count = sum ( 1 for ch in text if ch i...

SQL PLSQL Top Reserved Keywords

Image
To become perfect in PL/SQL is an art. Knowing of top reserved words helps you to be a master in SQL. Before you start knowing reserved words, wait one moment. The reserved words are similar to the words that you use in normal SQL. SQL, PLSQL Reserved Words PL/SQL Reserved Words A Video on Basic PL/SQL Basic PL/SQL Video Lesson for all professionals. Related Posts 32 Complex SQL Queries popular e-book Introduction to SQL and PLSQL by Ruchin Jain