SET Operations in SQL
There are four types of set operators UNION UNION ALL
Continue readingOnline Coding Tutorial For Programmers
SQL – Structural Query Language.
There are four types of set operators UNION UNION ALL
Continue readingSUBQUERY : The sub query executes (inner query) one before
Continue readingMultiple Row Function : Multiple row function is also called
Continue readingGeneral Functions are : NVL function (i.e NULL VALUE function
Continue readingDate : The oracle database store date in an internal
Continue readingNumber Functions are : ROUND – round the value to
Continue readingINSTR : INSTR – In string it contains four arguments
Continue readingLENGTH : It will display the length. Query: SELECT LENGTH(
Continue readingSUBSTR : Fetching the character. Substring is denoted by SUBSTR
Continue readingCharacter Functions are two types Case Manipulation Functions: UPPER LOWER
Continue reading