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...
I have an oracle strored procedure that writes a log file to Unix.
My question is how to understand the UTL_FILE.FOPEN command.
below is the code, the file on Unix comes out as:
load_...
Hello all,
I need some help with this PL/SQL syntax. Any help would be much appreciated. This is what I am trying to do.
Tables:
CUSTOMER
CUSTID CUSTNAME
1234 ABC C...
using oracle 10G
in a package I have two procedures that over load each other, they are declared as
Procedure FX (var1 in varchar2, var2 in varchar2)
Procedure FX (var1 in clob,var2 in var...
I have a code in place to send emails from orace pl/sql. I have to include few hyperlinks in the email body.
conn:= utl_smtp.open_connection( EmailServer, Port );
utl_smtp.helo( c...
Dear Experts,
I am using Oracle 11g1 on Linux
I would like to list all files in a given directory from PL/SQL using utl_file package and store the result into a collection (array). Is it pos...
i want to find the staff who delayed to submit report. Here the the minus sql but don't work...
the first sql canl get all staff, the second sql can get all ontime staff. any ideas? thanks
I am currently having a SQL script that basically does
SET SERVEROUTPUT ON
spool filename
begin
call a pl/sql proc
end
the pl/sql proc contains a series od DBMS_OUTPUT.put_line state...
I am trying to build a query in oracle that will be placed in SSRS2008. In the query I need to reference the current month as well as the previous month numerous times throughout the query. ...
I need to know how tbest to get threecounts from a table. below is an example of what I am trying to do but it says that I am missing an expression.
SELECT
(SELECT COUNT(*) FROM emp) AS ...
Hi all,
I have procedure/cursor that does the following
selects all row ids (say from table a) where the same id is in another table (say table b) and also matches an additional criteria....
I have a SP in PL-SQL to debug and modify accordingly, but first i have to understand this fully. I have pasted part of the SP and quoted it thorough "<<<<<<" where ever i have doubt. Please h...
I would like to parse a field and create four columns from that field. The field, for example may look like the following:
MAR-095 COMPUTER DEPT BINARY DIV W/C 101
I would like the re...
Hi
Is there a simple SQL function to count the occurences of a value in a field?
i.e
Field1:
f;fd;fdie;eytue
Count of ";" = 3
Thanks!
dnf999
Hi,
Can someone please help me with the following. I am trying to show inventory in transit with a price at that specific date. I have the two seperate queries working but can't get them to...
Dear Experts -
When I'm merging existing data (i do not want to use the update option) I get duplicates as described below and I want to remove them.
Do you have any ideas?
Sample file ...
I want to define a store proc function which accept undesigned number of paramters, similar to the build in function LEAST / GREATEST / DECODE.
The reason I need this because I want to write...
My NLLABELNAME table record gets created automatically
after my FMRESOURCE table record gets created.
Please post an updated trigger that might work.
Maybe something like "BEFORE INSERT ...
For some reason I just can't wrap my brain around TYPES and REF_CURSORS, they just don't make sense to me in how and when to use them. My understanding is now cursors should be avoided and ev...
I am maintaining a list of legislation contents in a table with recursive relationship.
Table Columns:
Content ID -||- Content Parent ID -||- Prefix ID -||- Content Text
1 -||- Null ...
Hi Experts,
I need your help in figuring out this problem.
So on this new web module, we have a section where admin can track how many users
logged on to the website i...
This code:
SELECT * from employee
WHERE hire_date between to_date('2008/08/01', 'YYYY/MM/DD') and to_date('2009/07/31', 'YYYY/MM/DD')
returns the error: ORA-01843: not a valid month
...
When I compile the following package, I get the following compilation error, but I can't determine what is causing the error. Please help!
Warning: Package Body created with compilation err...
How do I prevent the last name to be truncated , if they contain the suffix character as the last part of the name? Should I add another table with special names or can it be solved without th...
