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 res
Problem Dereferencing
With these types and tables:
CREATE TYPE MANAGER AS OBJECT (
MGR_ID INTEGER,
LAST_NAME VARCHAR(40),
FIRST_NAME VARCHAR(40),
PHONE ch
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
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?
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 SPs
Number Format
Hi All,
I have number '000000000050085' I want to format it to 500.85 Can any one give me the logic?
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 Sev
Oracle11g Patch issue
Hi all,I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AIX/oracle/Disk1/stage/Components/oracle.owb.rsf/11.1.0.7.0/
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 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 tabl
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: Argu
Can I use a loop
Hi buddies!
Once again with my doubts here.
Right now I am using this sql statement
p_blob(i):= package_email.read_file('shared_files','booki
! = ''
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' satement
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 like
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....
CR
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 t
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 a
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.
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 everyd
