Latest Answer : May be it is better to trace a select statment with on logon trigger.like:CREATE OR REPLACE TRIGGER SYS.ON_LOGON_ALL AFTER LOGON ON DATABASE WHEN (USER = 'MAX') BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=TRUE'; --EXECUTE IMMEDIATE ...
Hi,i want to know that,Will the functionality of these two statements:EXEC SQL SET TRANSACTION READ ONLY END-EXECEXEC SQL SET TRANSACTION READ WRITE END-EXECare same as “EXEC SQL SET TRANSACTION REPEATABLE READ END-EXEC”Give me the replacement for the above 2 sql statements.thanks in advance,rashmi
How do you get the return values in pl/sql when u exec them be sides assigning the values to Bind variables
What are the different types of collections supported in Oracle?PL/SQL datatypes TABLE and VARRAY, allow us to declare the collections nested tables, associative arrays, and variable-size arrays.
How do i write a function that returnsmore than 1 records from a tablefor example in sql server there is a solution as create function f1() return table asselect * from emphow do i do the same in oracle. plz help
I want to convert source Date format "CCYYMMD" to "CCYY-MM-DD23.59.59.999999" in to the target for example source date is 19980224it should be in target 1998-02-24.23.59.59.999999
Latest Answer : Hi Friend! If you deal with better performance You have to refer REF CURSOR and its more advantage and effecient of Exeqution.Thanks&RegdsRamki ...
Hi,We have to select some rows from a table using many conditions in the where clause. Then we have to write those selected rows to one flat file. I know that we can use UTL_FILE package to do this. Is there any better approach to do this??
Hi all,thank u for ur answers.and i have an adjustment in this question.actually data is not present in a table, it's there in some file.For eg. "Data" is the file, it contains information: 2489078905,2345678909 and so on...table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.got it, Right!Let me know if u have any questions.thanks.dev
Dear friend, my question is assume that we have created on table,on that table we are creating one view and one synonym know i have drop the table then status of view is invalid but status of synonym is not invalid pls give me the answer
