How to maintain the history of code changes of pl/sql?
Answer Posted / arup ratan banerjee
U CAN REFER ALL_SOURCE TABLE...
SELECT * FROM ALL_SOURCE WHERE OWNER='IHIS11'
AND TYPE = 'PROCEDURE';
U will get procedure body from this table
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How run sql*plus commands that are stored in a local file?
What is the use of sql trace?
Is sqlite good enough for production?
What is pl sql package?
what is a composite primary key ? : Sql dba
What does the acronym acid stand for in database management?
What program will open a mdb file?
How do you write a subquery?
How to select 10 records from a table?
How is data stored on a disk?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Write a sql select query that only returns each name only once from a table?
What is an index in sql with example?
what is the use of set statement in tsql? : Transact sql
What are triggers and its uses?