Posts

Showing posts from June, 2025

HTML5 Semantic Tags

  Real-Time Product Feedback Page <!DOCTYPE html > <html lang = "en" > <head>     <!-- Character encoding to support all languages and special symbols -->     <meta charset = "UTF-8" >     <!-- Responsive design: ensures mobile-friendly scaling -->     <meta name = "viewport" content = "width=device-width, initial-scale=1.0" >     <!-- SEO: Page title shown in browser and search engines -->     <title> Product Feedback | MyOnlineStore </title>     <!-- SEO: Description for search engines -->     <meta name = "description" content = "Submit product feedback for SmartWatch X2 and other electronics at MyOnlineStore. Help us improve your shopping experience!" >     <!-- SEO: Relevant keywords -->     <meta name = "keywords" content = "SmartWatch, Electronics, Feedback, Online Store, Customer Reviews...
Post a Comment
Read more

Building a Real-Time Inventory System in PL/SQL

B uild a   real-time inventory system example   using: Inventory and transaction tables Data records A  cursor  for low-stock alerts A  trigger  for auditing sales ✅ Inventory System  Tables: tblProducts : holds product details and stock tblSales : tracks product sales tblSales_Audit : logs all sales automatically via trigger ✅ Step 1: Create Tables -- Product master table CREATE TABLE tblProducts (     product_id    NUMBER PRIMARY KEY,     product_name  VARCHAR2(100) NOT NULL,     quantity      NUMBER(10) NOT NULL,     price         NUMBER(10,2) NOT NULL ); -- Sales table CREATE TABLE tblSales (     sale_id      NUMBER PRIMARY KEY,     product_id   NUMBER NOT NULL,     quantity_sold NUMBER NOT NULL,     sale_date    DATE DEFAULT SYSDATE,     FOREIGN KEY (product_id) REFERENC...
Post a Comment
Read more

ORACLE 11g: User Authentication System with Stored Procedure and SQL*Plus Integration

Oracle 11g PL/SQL: User Authentication System with Stored Procedure and SQL*Plus Integration Creating the tblUsers and tblRoles tables with sequences and 6 records, creating a stored procedure sp_UserNameAndPassword that returns user details as an OUT parameter (using a record type), and modifying the login.sql script to accept username and password, call the procedure, and display the results in SQL*Plus.  The solution will include "what," "why," "how" explanations, comments, and adhere to coding standards with exception handling. Step-by-Step Solution 1. Create Tables and Insert Records Create the tables with sequences for primary keys and insert 6 records. -- Create tblRoles table with sequence for RoleId CREATE TABLE tblRoles ( RoleId NUMBER ( 10 ) PRIMARY KEY , roleName VARCHAR2 ( 50 ) NOT NULL ) ; CREATE SEQUENCE role_seq START WITH 1 INCREMENT BY 1 ; -- Insert 4 roles INSERT INTO tblRoles ( RoleId , roleName ) VAL...
Post a Comment
Read more