DEV Community

Discussion on: What Is Your Main Language?

Collapse
 
scottishross profile image
Ross Henderson

SQL and I use it with Oracles Application Express to create webapps for my company to streamline efficiency, secure data and reduce costs.

Collapse
 
stealthmusic profile image
Jan Wedel

I've came a across some APEX applications but I've never actually had the chance to see how they are written. So you actually write a web application in SQL?

Collapse
 
scottishross profile image
Ross Henderson • Edited

APEX (Stolen from Oracle's website).

This is the interface that we use to create a page. In it we can load up reports, grids, charts, trees, etc. All that can be manipulated using SQL, PL/SQL and JavaScript to show whatever you want.

For example: I'm using PL/SQL in my latest app to send both scheduled emails and SMS to customers, if they meet certain criteria, within our database by combining several tables that compartmentalise data, without exposing it to the world, using PL/SQL and RESTful services. It's insane. And that's only taken me a few weeks to create (considering I'd never heard of RESTful services until then).