![]() Related Questions Latest Answer : 1)Using DBMS_JOB package,we can schedule the job.There are number of built-in functions in that package to schedule a job.Ex:DBMS_JOB .SUBMITDBMS_JOB .RUN.2) Using DBMS_SCHEDULERTHIS I SYNTAX FOR CREATING JOBdbms_scheduler.create_job(ob_name ... Read Answers (6) | Asked by : kishorebabu 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 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 Can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures? How do you get the return values in pl/sql when u exec them be sides assigning the values to Bind variables Read Answers (1) | Asked by : srini 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
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||