Hi,
I've been experimenting with dbms_system.get_env but struggling to actually get it to do something other than show the variable to dbms_output
I'm using this to pass a integer value ...
I have created procedures in Oracle for inserting and updating data. There are 3 procedures ... Say...
Procedure A
Procedure B
Procedure C
All 3 procedures can be called directly throu...
Hello,
I'm working with the Oracle EBS 11i and I would need to monitor when a certain user assign a certain responsibility to other users. If this happen I would need an email to be sent from...
Dear experts,
This below SQl query is taking too long in the application.
I will appreciate if any one could suggest me a faster way to rewrite the query or any other solution..
the ...
Good morning guys!
I just started to work on a new procedure derived from a trigger. I receive two PLS00049 errors for the variables :new.LNG_GEBIET.
Can you please show and explain to...
Novice with Oracle DB here.
I have written a package (see below) and need to test it. I would like to run it and see the output of the select in my PLSQL Developer. How do I do it?
Hi All,
I have a procedure which has something similar to the following (simplied):
execute immediate
'INSERT INTO table (field1, field2, ...) ' ||
'SELECT ... ...
Hey;
I want to query based on
ATTR_KEY = 'jobCodeDesc'
ATTR_VALUE is
D position or starts with the work Bag
How can i do that
Thanks a lot.
SE...
The attached code contains BULK COLLECT..INTO..LIMIT statements that are failing to compile. I have gone over the code and for the life of me see no reason why. The compiler stops at the firs...
I have a case where there I would like to select the max date and if a date doesn't exist
I would like to bring back the record with the maximum date or if there is no date for the record, I ...
There is a private procedure in a package which I need to call from a standalone procedure. I cannot alter the package spec, as it is code supplied by our vendor. My procedure does something...
I have a Refresh Group that I want to destroy if it exists before I recreate it, but I need to suppress the error if the group does not exist. If this were a view I could use CREATE or REPLAC...
I have a composite key created in a look up table. It is comprised of two fields. I'm using this table as a domain table. When I reference this lookup table to my other table, can I reference ...
Hello guys!
I am currently working on a tricky statement and don't know how to achieve a conditional summing.
The query (below) produces an outcome such as:
BA_FINALNAME BA_FINAL AGGR...
Is it possible to solve this with SQL? TABLE 1 contains data where I specify field no and record no that I want to move to TABLE 2. Maximum number of fields will be up to about 20.
TABLE 1
...
I have the following complex view:
CREATE OR REPLACE FORCE VIEW myvu ("col1", "col1_TMP", "col2", "col2_TMP", "col3", "col3_TMP") AS
SELECT
t1.col1,
tmp.col1 AS col1TMP,
...
Hi experts,
I am attempting to build a Fact table in Oracle 10g rel2, and am stuck. I have two tables.
The SOURCE table:
CREATE TABLE source (id NUMBER, code VARCHAR2(50), many other fi...
I'm trying to declare a cursor to do this:
Basically we give it an item number (parameter i) and it lists all the customer ids who have ordered this item.
This is what I have so far -
...
Hello I'm trying to create the following procedure but it keeps on giving me an error.
[error]
Error(2,31): PLS-00103: Encountered the symbol ")" when expecting one of the following: <...
Hi
i am pretty new in Oracle and i have to maintain code someone else wrote.
i see query of count like this:
SELECT ' ' INTO cDummy FROM PD_GENERAL
why not to write :
SELECT count(1...
Hi Experts
i have data stored in LONG_RAW column, and i want to know
what the current size of column after insert data.
how do i do it?
10x
HI
i am "stuck" on a simple query: with case when i have syntax error. why?
SELECT
SP.SPEC_UDF_C93 CHECK_TAG,
--'' C000_C_ELEMENTO_JOB ,
case C000_C_ELEMENTO_JOB
when C000_C_ELEMENT...
I want to do the following
select columnname || value + 1 from tablename
so that i get results like this
DOG001
CAT002
BAG003
where the last 3 characters are increments by 1 for ...
Hi I am trying to achieve this any idea how to get this result.
Student ID Month Score
21 Jan-09 45
23 Feb-09 88
21 Feb-09 23
1 ...
Hey;
I have a table:
attr_user_id
attr_key
attr_value
ex:
n222222 department KA
n222222 identitysource A
n222222 identitysoucre B
n222222 costcenter 10
Actuall...
