How pl/sql source code can be protected?




Answers were Sorted based on User's Feedback



How pl/sql source code can be protected?..

Answer / abbireddy anil kumar

using wrap utility we can protect the pl/sql code
this utility can change the pcode into ascci format

Is This Answer Correct ?    8 Yes 0 No

How pl/sql source code can be protected?..

Answer / balakrishna

You can use DBMS_DDL.CREATE_WRAPPED to protect/encript the
code.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer




More SQL PLSQL Interview Questions

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,


Types of joins?

4 Answers   Microsoft,


Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

3 Answers   Infosys,


how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,


I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,






With out using count() function. How to the find total number of rows in a table?

6 Answers  


can we use out parameter in a function?Give an example.

4 Answers   TCS, Logica CMG,


Main diff between varray and nested tablea

3 Answers   Polaris, TCS,


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  


When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   HCL, Accenture,


How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  


How to perform a loop through all tables in pl/sql?

4 Answers   MBT, Evosys,






Categories