• Blog
    • Oracle EBS ERP
      • DBA
      • Developer
      • Application
    • Db2 Database
    • MySQL
  • About Me
  • Skills
  • Education
  • Employment
  • Contact

count record in table

  • Home
  • count record in table
Number of records in table

User can find out the number of record in table SELECT table_name, TO_NUMBER(EXTRACTVALUE ( xmltype(DBMS_XMLGEN.getxml ( 'select count(*) c from ' || table_name)), '/ROWSET/ROW/C')) COUNT FROM user_tables WHERE table_name LIKE...

/ Posted by Kapil
Categories
  • Application
  • Db2 Database
  • DBA
  • Developer
  • MySQL
  • Oracle EBS ERP
o
  • Extract & restore single mysql table from backup of databaseSaturday - September 04, 2021
© 2019 KS is proudly powered by Kapil Savaliya.