Forums Page 87
-
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…
-
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 concern mail address). That task should be done on everyday…
-
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)? Ex: select employees.emp_no, employees.ename…
-
Procedure with variable number of columns
Hi, I have a procedure that looks like this: PROCEDURE PROC(p_cursor OUT sys_refcursor) And in the procedure, I build up QUERY dynamically and the…
-
import table with dependency
Hi What is the best way to import table back which has dependency? SQL> create table test (a number); Table created. SQL> create table test2 (b…
-
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 Oracle Text Index on that table/file column…
- Advertisement
-
Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I have hard time contacting our DB and I would…
-
! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement to NOT TRUE and skips onto the next 'IF'…
-
Can I use a loop
Hi buddies! Once again with my doubts here. Right now I am using this sql statement p_blob(i):=…
-
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 Function we are getting the error like Error is: Arguments…
-
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, after this I have to get the new id from the second table…
-
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 materialized view. But the number of columns is about 200. So i…
-
data type in column definition
Hi, I create a table with column called "Direction of Travel code ". The travel codes in the functional spec are numbers. In the column definition…
-
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 problem I can Found until now. (Even, you can see SQL…
- Advertisement
-
Number Format
Hi All, I have number '000000000050085' I want to format it to 500.85 Can any one give me the logic?
-
PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing following insert statement. I am new to Oracle…
-
cyrillic string conversion question
Hello, First time here... I would like to know if there is a way to convert a text string from cyrillic to latin. Should I use a function?
-
Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and timestamp is specified 10-11 am data look like…
-
Problem Dereferencing
With these types and tables: CREATE TYPE MANAGER AS OBJECT ( MGR_ID INTEGER, LAST_NAME VARCHAR(40), FIRST_NAME VARCHAR(40), PHONE char(10) ); CREATE…
-
am I using this for loop correctly
Dear buddies! Right now I am generating a report with some details for all the dealers. I am required to separate the report for each dealer…