I am trying to write to a local file from a PL/SQL script. In order to do this, I am attempting to use the TEXT_IO package in PL/SQL.
I have so many complex join queries, for which I want to return the nu开发者_运维技巧mber of rows affected.
I am trying to develop an ANT script that calls SQL*Plus and executes a SQL file. Using the following:
I\'m developing a c# application to automatically e开发者_高级运维xecute sqlplus. I would like to find a way to use the set lines, set pages.. and spool command to create an output file of the proper
I\'ve added an index to my table with the command: CREATE INDEX patient_index ON radiology_record(patient_name) INDEXTYPE IS CTXSYS.CONTEXT;
I have a sql script file that creates tables and inserts data. The server runs on Oracle 10g. When I use sqldeveloper (remote computer) and I run my script everything is perfect. But when I go on th
I have one employee table...this table has 5 columns (empname, empgsm, empsal, empaddr, empdep) ...it has 10 records. I\'ve created 10 users equivalent to the empnames colu开发者_如何学编程mn in the t
I am using the \'SET MARKUP HTML ON\' option to output a result table from a query to html using SQLPLUS.
I created a function in oracle that inserts records in specific tables and return an output according to what occurs within t开发者_C百科he function. e.g (ins_rec return number)
How to find out if a开发者_开发技巧 column is an auto increment field in oracle?You can\'t. Oracle doesn\'t have auto-increment fields.
加载中,请稍侯......