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.

Write a sql select query that only returns each name only once from a table?

0 Answers  

---

Is id a reserved word in sql?

0 Answers  

---

How many types of cursors supported in pl/sql?

0 Answers  

---

What are the sql commands?

0 Answers  

---

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

What is magic table?

6 Answers  

---

What are the query optimization techniques?

0 Answers  

---

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

---

Why trigger is used in sql?

0 Answers  

---

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

---

What is a behavioral trigger?

0 Answers  

---

Does truncate need commit?

0 Answers  

---