/sql-scripts

Useful SQL Scripts

Primary LanguagePLSQL

Dynamically Viewing Columns of table

  • use of DBMS_SQL package
  • Determining colums of table - which is passed as argument to function.
  • full text of sql scripts will be known during runtime
  • Input params: view or table name
  • Output params: CLOB which contains the result of query

Query the Paginated Data

  • use of DBMS_SQL package
  • Pagination of data by the predifined colums
  • Input params: table name, page size, page number, sort data(column_name, sort_type)
  • Output param: REF Cursor which can be consumed by other functions or client apps
  • Test scripts can also be found here(https://github.com/egasimov/sql-scripts/tree/master/pagination/test)

**PL/SQL | Dynamic SQL ** Further Information