I am using Oracle forms, and sometime in the last 7 months web.show_document() stopped working. All I am wanting to do is view a pdf that is stored in the db. Right now I download the pdf to...
Experts please assist,
I am attempting to create a trigger that will call a procedure to insert data from one table to another when a field is updated in the source table. I apparently don...
Can any one give some ideas to write a sql statement which has functionality of similar to using decode with multiple expressions.. for eg.
table has name, type, cost
data : name1, type...
I have a select all statement, but I want one of my fields (a zip code field) to be formated to pull in with only the first 5 digits. Where and how can I stipulate that?
SELECT *
FROM <ta...
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, I am trying to compile a package and package body. It give me the error message: PLS -00103: Encountered the symbol "Create".
Any help will be appreciated!
I am using Oracle PL/SQL 10. I would like to join several tables together, but the field that I join on is dependent on the values in one of the tables. I was trying to insert a case stateme...
How do I use EXISTS in the query below?
I was told that EXISTS replaces IN ???
I am using oracle 10G database. I am trying to execute dynamically created sql using execute immediate. The sql text formed were having length approximately 90000 characters. The query generat...
I have a table tmp(Digits vachar2(20))
There are values for Digits
Digits
53
532
987
when I use query statement as
select Digits from tmp where
REGEXP_LIKE('532689', ' ^ ' || Digits) ...
I am using Oracle 10 and would like to write an update query to remove a leading space that was put in the last name field by mistake. I have figured out how to find out what records have the...
I need to get the "date modified" from a file using pl/sql. I've looked at UTL_FILE, but I can't seem to find anything there. Is there a way to retrieve this date?
Hello,
I have 2 large files with different file names that I have to load into the same table. When I am specifying the INFILE in my script, is it possible to list multiple file names? If i...
Hello,
I've created the following JOB:
-- Killare un eventuale JOB gia' presente col lo
-- stesso nome NAZIONALE.AGGIORNA_ANAGRAFICA_IMPRESA
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_J...
How do I select from the below the last transaction on a specific day?
Is there a problem with this code? Is this an infinite loop? Is there a better way to exit it?
If I fetch all records from the cursor won't the not found if block eventually be entered?
Hi,
I'm trying to generate a unique identifier to user as the primary key for an insert into a table.
One of the columns in the table is a person_id, and I need to use the first 7 numbers ...
Hello All,
I need some help with my exception . The loop is terminating as soon as the exception is raised, but I would like it to continue to search for the rest of the values (where test...
I use WEB.SHOW_DOCUMENT to run reports from a form, I need for security reasons to hide parameters of the report in the browser address bar, how to do that?
I am trying to keep to tables on to different databases in sync. Every time an insert on the local table I want to insert the same record on the remort table. I do I write the trigger to do this?
Hi all,
IFOR r IN stagingTableRecords
LOOP
BEGIN
SELECT * INTO u FROM &2..users
WHERE email = r.email; --> email ex...
I need the cursor to be build dynamically ( the select statement ) . I am passing the parameters and finally the statement gets build and stored in a variable.
i am attaching the variable to ...
I am calculating some values in PL/SQL and just need to know how to format the out values to a certain precision...
so outval = 2.4433454
I want outval to be 2.4
what is the code t...
For example in the function
Enter
Select task_status
From task_table
Where task_id = passed_id
Load the results of the selects into an array
Return the array back to the modul...
Can you tell me why I get the ORA:00918 error 'Column ambiguously defined' in the script below?
