Hi,
Need your help. I am very weak on this. I want to put below output of below sql to my UTL_SMTP send by a trigger in the code section:
Code:
-------
select * from ETL_ERR_EXT_LOTS_...
My date field is YYYY/MM/DD
I want to create a list of birthdays by month from dbo.employee
SELECT last_name, first_name, birth_date
FROM employee
WHERE
The WHERE statem...
I am using select max(date) in a subquery and it is taking a while to return the results of the query. The amount of records that is being return are approximately 17,000 records. Is there a...
I have a stored procedure that is being called in a loop for emailing.
When I run the stored procedure, after emailing about 180 times, I am getting the below error -
ORA-30678: too many o...
sqlplus login as User system:
want to access v$database to get the database name out by
EXECUTE IMMEDIATE 'select name into v_DBname from v$database';
I got the error:
ORA-00942: t...
Hello Every one,
I have a merge statement ,a nd i am getting the above error.
I have a source table and target table, and I want to fill the target with source.
please have a look @ my ...
How do I select from the below the last transaction on a specific day?
Hi
how can i compare two date/times in pl/sql oracle ??
assume i have the folowing numbers:
hh number; -- hour
mm number; -- minutes
this will be (hh:mm)
hh_db number; -- hou...
Hi All,
I'm trying to run the following as user test
exec dbms_system.get_env('ORACLE_HOME',:ORACLE_HOME);
PLS-00201: identifier 'DBMS_SYSTEM.GET_ENV' must be declared
I've tried ...
I am trying to accomplish something like this:
Dell Desktop V305
- Model: Black - 23877487y24y
- Mother Board - Intel ....
- RAM - 3 GB DDR
HP Printer
- Ink Jet C 7770
- 4 Catridg...
Does anyone have a custom function or know of a built in function that could be used or called within this code to HTML-encode the XML between the <message> tag below?
The desired result ...
I am trying to debug a simple pl/sql code using SqlDeveloper 1.5.1
Though I am able to get connected to the database, I get an error while establishing connection to debugger.
The error ...
I need to put a "Re-Query" button on a form. It will be used to run the back end procedure that inserts data into a table. The same procedure that was run at noon the day before. It is desired...
I was trying to acheive this:
DELL BLACK 537 - DESKTOP ONLY D250S1
- 250GB
- 2GB RAM
- 3 YR LIMITED WARRANTY
- 7 DAYS FROM RECEIPT, UNOPENED
- ATI RADEON 3200
- BLU-RAY COMBO
- ...
Hello,
This evening I have to create a PL/SQL stored procedure composed by 300.000 lines of text.
Is is possible, or there is a length limit??
Hello all,
I want to pass to a stored proc a list of Customer ID's and then I need to get and values from another table for this list.
For example:
I would pass a comma or pipe whatever...
I have following SQL code. It works fine but when I put this code into a cursor, "select cursor(<select statment>)mycur from dual", screen hangs.
I have also seen in some cases where the se...
Hi
I am new to Oracle but I want to return a string of text from a select if s value is null and the value if it is not null
In sql server I would do this by
select case when table.field ...
I want to query a table using 'execute immediate' function, but I got a ' missing expression' error in pl/sql,
thanks in advance.
Hi,
I need to rotate an image on oracle forms 10g, can anybody help me on that.
Best regards,
Malaz
I am using Oracle 11.3.00 with Oracle 8i
I am adding code into custom.pll to load a value into an Oracle built-in form
if (form_name = 'OEXOEMOE' and block_name = 'ORDER')
then
dec...
Hello guys! I have a special request that I'm focussing on. I have a couple of select lists in my application that contain tree species.
On the first page the user has the opportunity to assi...
Hi
i want to select an item inside the select like in SQL
but i have to do it in PL/SQL.
select isnull(test,'')
how do i do it in pl/sql?
10x
I need to rwrite this query using an OR rather than a union. I have never done that and need help on how to do it. I've been looking on Oracle PL/SQL programming book by Steven Fewerstein but...
I need line 7 of this script to evaluate the field e.pct and, if it is not blank (NOT NULL), then the WHERE statement should select both l.ded_num='553' AND l.ded_num='567'. Conversely, if e...
