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 |
Which command is used to delete a package?
What are the benefits of pl/sql packages?
Is sql pronounced sequel or sql?
Does sql between include endpoints?
What is the basic structure of PL/SQL ?
What is a self join ?
<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?
How can you view the errors encountered in a trigger?
What is ttitle and btitle?
what command is used to create a table by copying the structure of another table including constraints ?
wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
full outer join syntax