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 n

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

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

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 procedur

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

How to schedule the a job?
Hi,
I have prepared a task ( i.e. a procedure is prepare the file and send the same to con

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

Procedure with variable number of columns
Hi, I have a procedure that looks like this:

PROCEDURE PROC(p_cursor OUT sys_refcurso

import table with dependency
Hi

What is the best way to import table back which has dependency?

SQL> cre

Oracle Text CTX_DOC.snippet slow
I have a table (FILE_TABLE) that contains a blob column (ft_file) and I have created the following O

Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Can I use a loop
Hi buddies!

Once again with my doubts here.

Right now I am using this sql stat

Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL

I face problems to extract data from one table and insert it in another one
Hi,

For modifications, I have to extract data from one table and insert it in another one

At max how many columns is advisable to create in a table/view
Hi All,
I have two transaction table from which i want to create a simple view or material

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
OK, I think but have a problem, only 1 pro

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me