How pl/sql source code can be protected?
Answers were Sorted based on User's Feedback
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 |
Answer / balakrishna
You can use DBMS_DDL.CREATE_WRAPPED to protect/encript the
code.
Is This Answer Correct ? | 6 Yes | 0 No |
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 |
What are the popular database management systems in the it industry?
What is the command used to fetch the first 5 characters of a string?
What is the basic structure of an sql?
What are the parts of a sql statement?
what is mean by forward declaration and where we'll use it.
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
what is a stored procedure? : Sql dba
Can We write bulk collect statement in triggers?
Can we use distinct and group by together?
How to sort the rows in sql.
Can we use two order by clause in query?
Can we have two clustered index on a table?