The PS4 can upload screenshots from both within and outside of games. To capture and upload a screenshot, press the Share button on the DualShock 4. This takes a snapshot and opens a menu.
DROP TABLE goes further than a TRUNCATE in that it actually removes the table from the database completely. This includes removing all associated objects, such as indexes and constraints. If you dropped a table, not only would you remove all the data, but the structure as well.
In my experience, you rarely encounter the CONCAT function. Instead, the || operator is almost universally used by PL/SQL developers. If either of the strings passed to CONCAT or || is NULL or ââ (a zero-length string), both the function and the operator simply return the non-NULL string. If both strings are NULL, NULL is returned.