Representation State Transfer is the new industry standard of building technology neutral API’s. REST API are essentially web services to…
Tag generate
First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…
— Get DDL from impdp — The below command will not import the dump, but will just create a .sql…
— Insert statements dynamically — Select ‘insert into abc values(‘||col1||’,’||col2||’,’||col3||’,’||col4||’);’ from xyz;
Shell Script to generate a column seperator report in SQL*PLUS using a shell script. It can be opened in Excel…
This is a script to query a table, generate the result in HTML and send an email using mailx for…