 Related Questions not known yet Latest Answer : The wrap utility takes a readable, ASCII text file as input and converts it to a file containing byte code. The result is that the DBA, developers or anyone with database access cannot view the source code in any readable format. ... Read Answers (6) | Asked by : abhishek 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 ... Read Answers (9) | Asked by : SumanNaidu.S What is cursor? Explain the types of cursor and write one implicit cursor program to check how many records deleted from table? Read Answers (6) | Asked by : indranil In PL/SQL I need to get like this scenario. if I am doing manipulation on a table, I need to display In PL/SQL I need to get like this scenario. if I am doing manipulation on a table, I need to display a record as Non-Updateable. It need to show a message to the user. How it is possible.Thanks in Advance. Read Answers (7) | Asked by : murthy Hi, in Cursors this is the Scenario.if i am manipulating the data of a table which has 10 records,i need to go to the 5th record.how is it possible?What is the Exact usage of Ref Cursor? Read Answers (1) | Asked by : murthy Latest Answer : Hi,Use the V$OPEN_CURSOR view to know how many cursors are currently open in the database.Guna Sagar Challa ... Read Answers (1) | Asked by : Amitava Latest Answer : Yes you can pass the whole select statement of the cursor dynamicaly, see ref_cursors.There is also a system package sys.dbms_sql which allows everything to make dynamically. ... Read Answers (5) | Asked by : sweety Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is it Latest Answer : First create a Trigger and with Procedure you insert records.The :new will take the new values.So use Triggers in Procedures. ... Read Answers (1) | Asked by : p Latest Answer : hi ,U can use the PRAGMA Function.I.e Autonomous Function to come back to normal stage in Mutating table. ... Read Answers (1) | Asked by : ranjan
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
