Nadz-Blog

This article describes how to deploy multiple pl/sql files (.api, .sql, .etc) at once using command prompt. First of all you have to store names of the plsql fiels in a text file in below way and save it in the folder where your plsql files are saved. Then open the command prompt and  change directory path to where your plsql files and text file is saved. Then type below commands in the command prompt and press enter. sqlplus/nolog conn username/password@service_name Then write @ sign and drag and drop the text file to command prompt or type the path of the text file. Press enter button. Do not forget to type @ sign before the path of the text file. Now all oracle files included in text files are deployed in your oracle database at once. If there are any compile errors in your db files, those are shown in the command prompt clearly. If There are more db files, it is difficult to type all file names in the text file. So you can create a script for this. Ope...

What is Conditional Compilation? PL/SQL source code is compiled selectively based on the compiler directives. Therefore, in the compile time code can be different according to conditions. Why do we need Conditional Compilation? Using conditional compilation features, we can include version specific features to our PLSQL source code. Therefore, In any production environments which use different versions,  Code is compiled and application is running properly without any issue. Assume, in development environments, we have developed multiple components such as component A for finance, component B for manufacturing, and component C for Sales. Now if we call methods written in component B for packages in component C, there is no issue when compiling and running particular code since all the components are properly deployed in the development environment. But, assume one of our customers install only component C in production environment, now when compiling the codes it gives e...

Google has provided its users to create a simple and powerful custom search engine. You can follow below simple steps to crate your own search engine Go to http://www.google.com/cse Give URL of the sites that you need to emphasize when searching, select the language and give a name to search engine.  Then you  will get your own search engine.  Then Start to search :)) This allows users to get uninterrupted browsing experiences with speed and simple search.

Would you like to know that your computer is a girl or boy? If so Try this :) Open your notepad Copy and paste CreateObject("SAPI.SpVoice").Speak"Hi Darling, How are you"  Save as computer_sex.vbs Run the file Now what you  hear? If you hear a male voice you have a boy computer, if it is a female voice, well, you have a girl computer. I have a boy computer :)). How is yours??  Also you can get the name of the voice owner by including below code. Set VObj = CreateObject("SAPI.SpVoice") For Each Voice In VObj.getvoices I = I + 1 VObj.Speak "Hello I am " & Voice.GetDescription & " and Nice to meet you" Next   

In C#, when we override methods we have to keep remember some important points. Assume there is a parent class called ClassA and it has a method called method().  If we are going to override that method in  a subclass ClassB, we have to use virtual and override keywords properly in suitable places. virtual should be used with method() in parent class and  override should be used with method() in sub class. If we do not use these keywords properly Overridden functionality  is not working properly.  namespace BasicLangEx {     class ClassA     {         public virtual void method()         {             Console.WriteLine("Method A");         }     } } namespace BasicLangEx {     class ClassB : ClassA     { ...

In this post I hope to give some knowledge about the Oracle Execution plan and  the some tips to optimize sql queries for better performances. Execution Plan Oracle can run Explain plan for given SELECT, INSERT,UPDATE, DELETE SQL  statements as below Oracle - EXPLAIN PLAN FOR SELECT customer_name FROM CUSTOMER; MySql -   Explain SELECT customer_name FROM CUSTOMER;   Then it displays the execution plan chosen by the Oracle optimizer, which contains the  sequence of operations used to run a particular sql statement. Execution plan contains,  tables, views referenced by the statement access methods for each tables and views (table access full,table access by index) join methods data operations such as sort, aggregate cost, cardinality parallel executions   According to the execution plan you can get the idea to optimize a given sql statement in  a proper way.Now I am going to explain the ways that can be used to tune/optimize the...

First I will say how to create a jar file for given java package using command prompt You can create Manifest file using note pad by including below mentioned contents                        Manifest-Version: 1.0                        Main-Class: Main Here manifest file is named as manifest.mf Here Main is the main class of the java project. In my example java project it only contains Main.java with below code.                                        public class Main {                   ...