I want read Unix environment variable in PL/sql script instead of passing to the sqlplus script, is there a way to do that?
Exception: -29532 ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.net.SocketPermission 192.168.101.1:25 connect,resolve) ...
I am developing an application with Java spring, hibernate and oracle and new to most of the technology. I have successfully used hibernate to interact with oracle tables with some help, but ...
I have datablock in a form contain 2 rows and 2 colums
I need to Display 2 records cpacified by where condition in this data block in oracle form
but
The problem it display only last reco...
I have the following problem.
We have some data that gets imported from various legacy systems. Some of these rows have a transaction number, while others do not. The rows are first loade...
Hi,
here is my procedure -
PROCEDURE usp_read_xml_file
( par_file_name in VARCHAR2,
par_doc_name in VARCHAR2,
par_success ...
I need to count the number of records within a table for multiple fields. I am curretnly using count for each filed. Is there a way to combine the count function?
Select count(MARKET) f...
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?
I am trying to run the following procedure from sql plus when I get errors for wrong count of parameters.
execute Process_This('A1000');
This is the start of the procedure:
Process_Th...
Hi,
I am running this query in oracle. But not able to insert % whereas able to update with other characters like ',' . I tried with '\%' ESCAPE'\' also. do help.
UPDATE TB_FININST_ACC S...
I have a situation where I need to have the ability to get one row in random from the result set of another nested select statement.
The random row that I want returned must be between 1 an...
Hi Every one,
i need to find the table name from the schema( which has lots of tables in it) using column name.
like the column name is ' seriel_order '
and i need to find in which ...
Hi,
We have Oracle 10.2 version installed. We have several procedures in a package. We declared a weak ref cursor as TYPE RefCursor IS REF CURSOR; in the package definition and use it in th...
I'm trying to make my CTL file insert an "N/A" if it incounters a NULL or blank value. I need help.
Hi,
I have two tables.
Table1
id col1 col2 col3
Table2
id col4 col5 col6
I need a trigger on table 2 which would do this
update table3 set col1= (select sum(table2.col5) from t...
Hello I am kind of new the oracle world.
I am using TOAD and I have an oracle stored procedure which opens a ref cursor and just selects data from a table and returns the ref cursor. I want t...
In Oracle 10g PL/SQL, I have a delete statement in a stored procedure. It is not in a cursor. I want to see the number of rows I've deleted. I can use the dbms_output.put_line package. I sh...
Hi........
I m pankaj. I m trying to create a table through oracle user defined function using execute immediate dynamic sql in which i want to create table whos name and colums are given by ...
Hi,
I have created a procedure that searches tables in the database.
Table name is decided at run time and i want the output of the query to be in REF CURSOR or PLSQL table to increase the ...
Hi Experts
i have to following system ...
i have "Employee Management System" , part of this system is attendance time, this means that i have an external elcotoric clock , and the employee ...
Hi,
Our application calls a stored procedure to disable a foreign key constraint (simple, alter table table_name disable constraint constraint_name), and sometimes it can't because of ORA...
I would like to insert data into a table base on whether a column value is null or not null. How would I do that using sqlldr?
I need to write a function such that it will have an insert statement
and this function should return the number of rows inserted into the table. How to do that?
My table name is my_table...
I am using Insert, Update, Select query on Oracle tables through my C# windows application project.
If my table has a column of datatype number can i insert or select value in query through a...
i need to get all the rows which are created from the beginning of the current day to current time...dont say trunc(datecolumn)=trunc(sysdate).i need other way.
