I am using toad for oracle to retrieve data from oracle database. I am using a query using IN clause. I have to pass 4000-5000 parameters to the IN clause. Is there any solution. There is an ...
Hi
I am trying to do export of some table which are more then 20GB.
The problem is the database is on remote server.
Is it possible to export dump file directly on to local machine.
How ...
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...
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...
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...
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...
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...
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 ...
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...
How do I select from the below the last transaction on a specific day?
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 ...
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 ...
Hi;
I have a query need to select column from a table:
If columne value = 0, show empty
otherwise, just show what its original value.
How can i accomplish it?
Thanks in advance
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.
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
- ...
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...
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 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...
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...
No idea how to manipulate ORA-00001: unique constraint with pl/sql this is my script :
I have a code in place to send emails from orace pl/sql and it works fine.
conn:= utl_smtp.open_connection( EmailServer, Port );
utl_smtp.helo( conn, EmailServer );
utl_smtp....
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...
