Emiliano CerasaniUnderstanding character functionsCharacter functions are named for their ability to process character data types. These functions accept character data as input and return…·2 min read·1 day ago----
Emiliano CerasaniUser input with ACCEPT and PROMPT commands in SQL DeveloperToday, we will explore another method for defining user variables using the ACCEPT and PROMPT commands, a reliable and robust way to prompt…·2 min read·2 days ago----
Emiliano CerasaniUnderstanding substitution Variables in SQLThis topic is essential for creating interactive SQL queries and is often included in SQL certification exams, making it valuable for exam…·2 min read·5 days ago----
Emiliano CerasaniData sorting in SQLToday, we delve into sorting data using SQL’s powerful ORDER BY clause.·2 min read·6 days ago----
Emiliano CerasaniBusiness in 24 hoursToday, I aim to start a business in 24 hours by finding an idea, conducting market research, and developing an MVP (Minimum Viable…·2 min read·Jun 5, 2024----
Emiliano CerasaniIS NULL operator in SQLIn this lecture, we’ll dive into the IS NULL operator, a crucial tool for handling null values in databases.·2 min read·Jun 5, 2024----
Emiliano CerasaniBest commercially available waterIn today’s article, we will dive into a detailed analysis of various commercially available waters to determine which one is the best. We…·2 min read·Jun 4, 2024----
Emiliano CerasaniTool for self-discoveryThe Johari Window is a psychological model that helps individuals understand their relationship with themselves and others. Developed by…·2 min read·Jun 4, 2024----
Emiliano CerasaniAre you ready for an existential crisis?Hello everyone! Are you ready for an existential crisis? Great, because today we are going to dive into some thought experiments. We’ll…·5 min read·Jun 3, 2024----
Emiliano CerasaniArithmetic operations in SQLOften, you may find that retrieving data as-is isn’t sufficient. Sometimes, you need to display your data after performing certain…·2 min read·Jun 3, 2024----