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 |
Why should I use postgresql?
How many LONG columns are allowed in a table?
How to change sql*plus system settings?
How to find only %th Highest Sal
Who is the owner of mysql database?
explain mysql aggregate functions. : Sql dba
how to enter characters as hex numbers? : Sql dba
How to test for null values?
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
give the syntax of grant and revoke commands? : Sql dba
Can we use join in subquery?
Is foreign key mandatory?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)