Questions tagged as 'sqlplus'

With the user SYS it is required to revoke the privilege EXECUTE of the table AWRRPT_HTML_TYPE however when executing the statement REVOKE EXECUTE ON AWRRPT_HTML_TYPE FROM PUBLIC; Displays the following message:   ...

I have a macro in Excel that generates a flat SQL file with INSERT statements to be executed from an Oracle Forms form, by means of an invocation to sqlplus. I am the developer and in my team everything works correctly, but the people who use th...

Hi, I am working with ORACLE 11g, making a query to the table through sqlplus, then I save the result of the query in a log. The problem is that there are two fields that return an amount of sum and have many characters so they do not look like...

I'm working with Oracle Database and I need to create a script that will generate an import file in TXT format. I'm using sqlplus and the spool command to save the queries but for more than try I can not accommodate the data: What I need is:...

I use the spool to capture the result of a simple query and pass it to a TXT that I place on my local machine in C: \ TXT. But I need to deposit that file in a remote directory using ssh. How could it be done? I was researching to see if from...