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

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

Answer / kuldeep123

take procedure or function that u want to wrap
e.g proc_out_data

step 1:- create a sql file and save into a directory.

step 2: go to file location through cmd

step 3: wrap iname=file_name_to_be_wrapped.sql


step4: check a new file is created with same name but extension

file_name_to_be_wrapped.plb

step5:- compile this nely created file's text

step6: your code is now wrapped.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,


Can a select statement fire a trigger?

0 Answers  


What are transaction and its controls?

0 Answers  


what is self join and how it works??

2 Answers   Infosys,


What is the use of primary key?

0 Answers  






Why use truncate instead of delete?

0 Answers  


Explain architecture of sql server notification services?

0 Answers  


Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  


What is the use of count (*) in sql?

0 Answers  


What is a Procedure ?

3 Answers  


Which is better trigger or stored procedure?

0 Answers  


Is natural join same as inner join?

0 Answers  


Categories