Forums Page 86
-
Batch Session SM35 stuck in status 'in Background
Hi Experts, I am facing a problem with Batch Input session SM35. The batch session if I process in 'background', it gets stuck and the status is"in…
-
How to have a log of all the status a VIM document had been ?
Hi guys, I’m using SAP Invoice Management plugin and the /OPT/VIM_ANALYTICS transaction. In order to display a list of how many tasks the users…
-
Recognising Revenue daily
Hello. Has anyone come across daily recognition of deferred income? We want to implement Revenue Recognition for a new project. The business wants to…
-
Supress some serveroutput but not all
Hi, I have a script I'm working on that uses plsql to create and RMAN script, this uses dbms_output and also accepts user input as variables. The…
-
How to form a xml form table with a single sql statement..?
Hi everyone, I don't know if this is going to be a duplicate thread but i couldn't find one exactly like this. Let me explain the problem first -- we…
-
AUTONUMBER PROBLEM
Hello Everyone, My name is Jones and i am new to this forum and to oracle. I am using oracle 9i. the below mentioned is my problem. SQL> CREATE OR…
- Advertisement
-
Pass sql into pl/sql and create RMAN duplicate script.
Hi, I'm new to pl/sql and I'm trying to write a script that will generate some RMAN commands to do a database clone. I want to able to run the script…
-
insert Multiple rows into the table from that table data
Hi All, I have a requirement like to insert mulitple rows into the table from that table data only(I need to replicate the data). In this table…
-
Getting number of affected rows in SQLPLUS..
Hi everyone, I have a shell script where i am invoking sqlplus, running a query and saving the result in a spool file in a .csv format. Now this file…
-
How can I Compare two xml documents?
Hi all, I am doing a POC for my project and I am using XE database 10g version. I want to make a comparison between two xml document stored in a…
-
retrieving policy name inside the function called by this particular policy
Hi there, I've playing around with dbms_rls package, trying to set up some security repository, linking users to what columns and row values they are…
-
How to insert random unique values in 2 columns ?
I have table with 2 columns Create Table code_for_code ( first_code varchar2(10) unique not null, second_code varchar2(10) unique not null ); and i…
-
present value of sequence?
Hi Please help me to find out the present value of sequence? Thanks
-
Logging and nologging bulk insert
Hi, oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production I am trying to use Append during bulk insert? example: insert/*+…
- Advertisement
-
Error when call dll from oracle
Hi all, please help me! I have dll write C language, I want call it from oracle procedure but it throws the error: "ORA-28546: connection…
-
Help on query replacing the date
Hi Pals, i want to replace the current date in a column to some value say C or D or any numeric value , likewise the NVL function which replaces the…
-
Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the tables with records more than say 100 or so at on…
-
Oracle Connectivity
Hi Every One, Can we access SAP from oracle database.If it possible then please specify the list of steps(i.e connectivity) to access SAP from oracle…
-
present value of sequence?
Hi Please help me to find out the present value of sequence? Thanks
-
Error when call dll from oracle
Hi all, please help me! I have dll write C language, I want call it from oracle procedure but it throws the error: "ORA-28546: connection…