Answer / abbireddy anil kumar

using wrap utility we can protect the pl/sql code
this utility can change the pcode into ascci format

Answer / balakrishna

You can use DBMS_DDL.CREATE_WRAPPED to protect/encript the
code.

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 it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

---

How is sql used in oracle?

0 Answers  

---

define sql update statement ? : Sql dba

0 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

What language is oracle sql developer?

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

Is pl sql still used?

0 Answers  

---

what is commit? : Sql dba

0 Answers  

---

How do you clear the screen in sql?

0 Answers  

---