Why should you care?

If you want DBA, backend, or ERP jobs in India and globally, Oracle skills show up in interviews and production systems every day.

See it live — copy this example

Run these statements in SQL Developer or SQL*Plus against your lab PDB. Prefer a practice user — not SYS — for application SQL.

-- Connect as a normal user in SQL Developer / SQL*Plus
SELECT banner FROM v$version WHERE banner LIKE 'Oracle%';

SELECT user AS current_user, SYS_CONTEXT('USERENV','CON_NAME') AS container FROM dual;

What happened?

• v$version shows which Oracle release you are on.
• dual is a one-row helper table.
• SYS_CONTEXT tells you which pluggable database (PDB) you are using in multitenant setups.

Practice next

1. Open SQL Developer and create a connection to your lab PDB.
2. Run the SELECT from v$version.
3. Run the dual query and note your user and container name.
4. Add SELECT * FROM dual;
5. Change the LIKE filter on banner.

Remember

Oracle stores relational data and runs enterprise apps. SQL queries data; PL/SQL adds procedures and logic. Know your version and which PDB you are connected to.

Banking core starts here

A private bank runs customer accounts on Oracle. Every teller screen eventually hits SQL against Oracle tables.

Outcome: You can explain what Oracle is and verify your lab connection.