I get an error when compiling the following query in report builder.
"A non numeric character was found where an numeric was experted."
I believe report builder do not like my date format (...
Dear Experts,
I have a table which is used to store the XML data in a CLOB column.
I need to ZIP a group of XML records (i have condition and query too for the group) and store then in an...
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....
Hi,
I have a column in which the data is stored in two lines.
Example: COMPANY_NAME column has value:
HYPER PVT LTD,
UNITED STATES.
the ...
I would like everytime someone tries to delete a record for the trigger to reject a deletion and make records in the log. What does this error mean and whats wrong with code.
Hi All,
I'm a newbie and need some pointers to get going to do the following:
Have table_X and table_Y (table_Y is a database link)
table_X and table_Y have the same fields including ...
Hi, is there a way that I can pass in a datatable or any other type of collection list of data to a CLR function, I resorted to using delimited strings.
I would like to create a series of custom PL/SQL Packages/Functions/Procedures that are similar to native Oracle builtins in that they are essentially available to all users without any object...
This was a solution from a previous question. However, report builder is erroring out on the date format(to_date). On the front end user will be inserting a date format not a string;example 0...
I have a table like this:
APP_NO ACTIVITY_NO REQUIRED DONE
1 100 Y Y
1 101 ...
The user can select multiple entries from a picklist.
One of the entries selected may not be returned in the report.
I would like to alert the user that the selected value does not exists....
I have an update query that modifies values in table2 based on values in table1.
update table2
set field2 = 'hot'
where exists (select 1 from table1 where table1.pk=table2.pk AND table1...
I have two table, Table one with student id's and student firstnames, In another table I have just students fullnames.
I need help with a query so that I can match firstname with fullname, Th...
I would like to know how to construct the following query to sum the number of course statuses for a specific career_group
SELECT DISTINCT count(distinct person_name)num_of_course_status,care...
Hello experts! I have a slight problem this morning and it seems as if I just can't find the mistake I made. My statement doesn't run and I receive an ORA 00979 error (Not a group by expressio...
I've been struggling with this for quite some time now. Any help would be appreciated!!
:)
***********
Scenario: I need to get the Customer Number (distinct), Date of Last Sale and Paymen...
I am looking for some PL SQL code to string off the a part of the Last Name field
the entry may look like this :
"de la Rosa Martinez Jr" or like "de la Rosa Martinez Rodriguez III"
I li...
The following code works great for importing a csv file and inserting the records into tables..
but the last record is not read unless there is a blank line after it..
what needs to be cha...
I have a number for example,, 1234.5678 and I apply
SELECT to_char(12345.5678,'99999.999') FROM dual
but i get a rounded result of 12345.568
Is there any function to stop round...
I am trying to branch a query based on the existence of accountNo. In SQL i would use an if /begin/ end/ else statement. can you help me with the Oracle Syntax for this?
when i am trying to creating this procedure i am getting the bellow erros. could you please tell me what is the issue in the bellow code.
Errors:
25/11 PL/SQL: SQL Statement ignored
27/1...
Hi,
there's some stored procedure that returns a ref cursor:
some_proc(input1 in varchar2, outcur out ref_cursor)
The rowtype of the returned cursor, or the record structure, is not ...
Consider the relational scheme which stores info on the departments of a fi rm, the
employees, the department in which each employee works, and each employee's supervisor.
All the fields n...
Is there a way/view to find if application leaves open cursors?
How would open cursors impact oracle? would they consume a session after someone exits or is it basically leaving areas in memo...
Using oracle 11g
Is there a function to count the occurence of a delimiter in a string.
For example:
UNIT-1 - DEPT2 - DIV3 - W/C 3 the number of occurence of ' -' hyphen preceded by a sp...
