Array of objects C# example – An array of user defined class objects can also be created the same way as we create array of
Query to find the data which not common in two tables – Learn how to select the data from table TAB1 that are not exist
Parametric cursor in Oracle PL-SQL- Learn how to pass values to Explicit Parametric cursors with OPEN statement and with for loop. Also Learn how to
Cursor attributes in Oracle – Learn about Cursor attribute types related PL-SQL Implicit Cursor and also Learn how to use the attributes with Examples. Cursor
Query to find average fee of their department – Learn how to write the queries to find average fee paid by students in department wise
Query to select the rows that have give input value in any one of the column. Let’s say suppose you have the table naming with TEMP_TBL
CTE – Learn how to use a temporary query using with Clause for referencing the select , insert, update, delete statements. CTE CTE stands for
SQL DUAL Table – Learn when to use dual table in SQL with example queries. DUAL DUAL is a dummy table that is automatically created
IN ANY SOME ALL operators in PL-SQL – Learn about in, Any, Some, All operators usage in PL-SQL with example Programs. Let’s Create a Student
Decode function vs Case statement in PL-SQL – Learn how to use Decode function and Case statements in the situations where you need to use