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.

What is pragma exception and how, when, where us

5 Answers  

---

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

How do you get column names only for a table (sql server)?

0 Answers  

---

What is the difference between drop and truncate commands?

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

What does varchar include?

0 Answers  

---

What is compiled query?

0 Answers  

---

How do I start sql profiler?

0 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

can i write pl/sql code in a package

2 Answers  

---