sqlplus
PL/SQL TEXT_IO package
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.[详细]
2023-02-27 01:24 分类：问答To return the no of rows affected in oracle for complex queries
I have so many complex join queries, for which I want to return the nu开发者_运维技巧mber of rows affected.[详细]
2023-02-25 07:38 分类：问答SQL*Plus return code when invalid username or password
I am trying to develop an ANT script that calls SQL*Plus and executes a SQL file. Using the following:[详细]
2023-02-24 06:56 分类：问答automatic execution of sqlplus scrpts, use set lines, spool commands to create an out put file with the required layout using c#
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[详细]
2023-02-21 03:38 分类：问答oracle identifier 'ctx_ddl' must be declared - adding a dbms_job
I\'ve added an index to my table with the command: CREATE INDEX patient_index ON radiology_record(patient_name) INDEXTYPE IS CTXSYS.CONTEXT;[详细]
2023-02-20 09:36 分类：问答Difference between sqlplus and sqldeveloper?
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[详细]
2023-02-20 03:33 分类：问答Limit user in sql plus to a single record in a table
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[详细]
2023-02-18 09:49 分类：问答Set the column width when outputting to HTML using SQLPLUS?
I am using the \'SET MARKUP HTML ON\' option to output a result table from a query to html using SQLPLUS.[详细]
2023-02-15 08:48 分类：问答executing a function in sql plus
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)[详细]
2023-02-13 09:33 分类：问答How to find out if a column is an auto increment field in oracle?
How to find out if a开发者_开发技巧 column is an auto increment field in oracle?You can\'t. Oracle doesn\'t have auto-increment fields.[详细]
2023-02-12 05:15 分类：问答
加载中,请稍侯......