Emiliano CerasaniUnderstanding character functionsCharacter functions are named for their ability to process character data types. These functions accept character data as input and return…2d ago2d 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…3d ago3d 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…6d ago6d ago
Emiliano CerasaniData sorting in SQLToday, we delve into sorting data using SQL’s powerful ORDER BY clause.Jun 6Jun 6
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…Jun 5Jun 5
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.Jun 5Jun 5
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…Jun 4Jun 4
Emiliano CerasaniTool for self-discoveryThe Johari Window is a psychological model that helps individuals understand their relationship with themselves and others. Developed by…Jun 4Jun 4
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…Jun 3Jun 3
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…Jun 3Jun 3