I’ve been exploring Oracle Live SQL recently, and it’s such a powerful way to practice SQL directly in the browser without installing anything locally.
In my latest session, I worked on creating a table for students and then modifying it to add new columns. The best part about using Oracle Live SQL is that it instantly shows whether your script executed successfully, making it very beginner-friendly.
✨ What I did:
Created a table called STUDENTS with details like ID, Name, Department, DOB, and Email.
Altered the table to add a new column for phone numbers.
Verified the script output to confirm that everything worked as expected.
💡 Key learnings:
CREATE TABLE is used for defining new structures.
ALTER TABLE allows you to modify existing structures without losing data.
Oracle Live SQL provides real-time feedback, which makes it an amazing tool for learning and experimentation.
🔥 Next steps: I’ll be exploring how to insert data into the table, run queries using SELECT, and then move into more advanced concepts like GROUP BY and HAVING.
Using Oracle Live SQL feels like having a mini database lab right in the browser, and it’s been super helpful in my SQL learning journey.
Top comments (0)