-
Expert Member
Tip of the day
Query to get the product of all the values of a column :
SELECT EXP(SUM(LN(col1))) FROM tablename;
-
Junior Member
Re: Tip of the day
use oracle wrap utility to encrypt your procedures and packages. But can't wrap triggers.
Jaya
-
Junior Member
-
Expert Member
Re: Tip of the day
wrap utility is used to encrypt pl/sql code.the wrap utility takes a readable, ASCII text file as input and converts it to a file containing byte code. The result is that the DBA, developers or anyone with database access cannot view the source code in any readable format.
in cmd type
wrap iname=sourcefilenamepath oname=ouputfilenamepath
-
Expert Member
Re: Tip of the day
Syntax for wrap utility is
wrap iname=input_file [oname=output_file]
Leave no space around the equal signs because spaces delimit individual arguments.
Output file name is optional because its name defaults to that of the input file and its extension defaults to plb (PL/SQL binary).
If you want, you may specify a different output file name and extension.
You need not specify the file extension for input file if its extention is sql.
ex:-wrap iname=c:\mydir\myfile
You need to specify extension if you are giving inputfile having differenct extention name
ex:- wrap iname=c:\mydir\myfile.prc
Wrap Utility encrypts only functions, procedures and packages.
String literals, number literals, and names of variables, tables, and columns remain in plain text within the wrapped file.
Last edited by krishnaindia2007; 02-22-2008 at 05:10 AM.
-
Expert Member
Re: Tip of the day
I created a procedure. After encrypting the procedure I dropped the procedure and then executed the encrypted file. It is working fine in SQL * Plus. But it is not supporting in toad.
In toad can we execute encrypted files?
Last edited by krishnaindia2007; 02-22-2008 at 05:43 AM.
-
Junior Member
Re: Tip of the day
hi
y not we can, can u post the returned error?
Jaya
-
Expert Member
Re: Tip of the day
My toad and SQL *Plus start in folders are different. That is the problem. Now it is solved.
-
Junior Member
Re: Tip of the day
hi
Tip of the day:
to minimize the fragmentations and improve query response time related to one particular table just reorganize the table in the following way:
SQL> alter table < table_name > move;
For best results, you can alter storage parameters of that table, before going to reorganize.
Jaya
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote