PinnedCing Sian DalSoftware Engineer Interview PrepThis is a personal note to prepare for Software Engineer position.Jan 21, 2022Jan 21, 2022
Cing Sian Dalnpm WARN npm npm does not support Node.js on UbuntuNormally you have tried:Nov 22, 2021Nov 22, 2021
Cing Sian DalInstall Oracle Instant Client on UbuntuHere are instruction steps to install Oracle instant Client on UbuntuNov 12, 2021Nov 12, 2021
Cing Sian Dalpm2 start for next start with different portIf you want to run your server-side NextJS with pm2 and different port, run this:Oct 12, 2021Oct 12, 2021
Cing Sian DalNotes on Database SystemsThe fundamental concepts necessary for designing, using and implementing database systems. It includes the fundamentals of database…Jun 25, 2021Jun 25, 2021
Cing Sian DalMaterial UI Data Grid Pagination onPageChange does not workYou only see the first page. Your state loads into the first page.Jun 14, 2021Jun 14, 2021
Cing Sian DalUsing Oracle SQL `offset fetch next rows only` for paginationIf you are using Oracle SQL offset :number fetch next :number rows only , you must know that offset does not represent page number.Jun 14, 2021Jun 14, 2021
Cing Sian Dal[Error: ORA-00933: SQL command not properly ended]Most of this error is due to extra ; in your Oracle SQL statement.Jun 11, 2021Jun 11, 2021
Cing Sian DalNodeJS express response cookie does not set cookie in client.In your NodeJS, you declare to respond with a cookie in its header:Jun 6, 2021Jun 6, 2021
Cing Sian Daloracle nodejs return empty rowsCheck if your rows are already commited in your database.May 19, 2021May 19, 2021