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 is called after appearing where clause
How do I pipe the output of one isql to another?
what is an index? : Sql dba
Why do we need pl sql?
What are sql indexes?
How can I delete duplicate rows?
How delete a row in sql?
What is procedure and function in sql?
Can we use having without group by in sql?
How is a process of pl/sql compiled?
Explain ddl statements in pl/sql?
Which is faster union or join?