Blog / Category
Query
4 articles in this category
Database Blog
How To Export Data Using Select Query In MYSQL
Introduction Exporting data using a SELECT query in MySQL is a common practice to extract specific data from a database and save it in a usable format. This all…
Database Blog
How To Generate Dynamic Numbers in MYSQL
Introduction: Generating dynamic numbers in MySQL involves creating a sequence of numbers or generating numbers dynamically in queries. This is useful in variou…
AR
Oracle R12 AR Lockbox Query
SELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch…
Oracle Application Blog
Oracle SQL to get the Menu and Submenu list against a responsibility
SELECT FRV.responsibility_name, fm.menu_name, FMEV.ENTRY_SEQUENCE, FMEV.PROMPT, FMEV.DESCRIPTION, SUB_MENU_FMEV.USER_MENU_NAM…