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 |
Can we create view in stored procedure?
How to write pl sql program in mysql command prompt?
What is user define exception and example
What is the difference between a procedure and a function?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
What are the string functions in sql?
How to display Row Number with Records in Oracle SQL Plus?
Can we insert data into materialized view?
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
What is a pragma statement?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is sql in oracle?
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)