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 the syntax for using sql_variant_property? : Transact sql
Can we use having without group by in sql?
What is function and procedure?
What are conditional predicates?
How do you know if a relationship is 2nf?
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c
Differentiate between syntax and runtime errors.
What are basic techniques of indexing?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Is pl sql a scripting language?
Write a unique difference between a function and a stored procedure.
How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000
10 Answers Mind Tree, Polaris, Sonata,