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 |
What are tables and fields in the database?
Does pl sql work in mysql?
what is dbms? : Sql dba
What does t sql mean?
Explain two virtual tables available at the time of database trigger execution.
How do you get column names only for a table (sql server)?
Can we call procedure in select statement?
Is sql a oracle?
what is meant by forward declaration in functions?
Is crud a cuss word?
how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing
What is recursive join in sql?
Oracle (3253)
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)