Get domain name from Email in Oracle SQL

How to get domain name from given email id in Oracle SQL (or) PL/SQL Very easy to get domain name from mail id like ‘thamaraiapex@gmail.com’ => gmail SELECT (substr(substr(‘thamaraiapex@gmail.com’, instr(‘thamaraiapex@gmail.com’, ‘@’) + 1), 1, instr(substr(‘thamaraiapex@gmail.com’, instr(‘thamaraiapex@gmail.com’, ‘@’) + 1), ‘.’) – 1)) as domain_name FROM dual; Result:- gmail Continue reading Get domain name from Email in Oracle SQL

Oracle Apex Customize CSS for Navigation Bar List

How to customize navigation bar list like background color font style? Yes, We can customize the navigation bar list items with User Defined Attributes Use 2nd Attribute to mention your CSS Classes. Mention your CSS Styles in your Global CSS or 0th page Style like below. .help_style .t-Button { font-weight: bold !important; background-color: red !important; } That’s it, now you can showcase your navigation bar list … Continue reading Oracle Apex Customize CSS for Navigation Bar List