Keep it Simple and Smart
A trigger is a procedure that is run automatically by the database when a specified SQL DML INSERT, UPDATE, or DELETE statement is run against a table or view. Triggers are similar to stored procedures. A trigger stored in the database can include SQL and PL/SQL statements to run as
» Read moreSYS_GUID generates and returns a globally unique identifier (RAW value) made up of 16 bytes. On most platforms, the generated identifiers consists of a host identifier, a process or thread identifier of the process or thread invoking the function, and a non repeating value (sequence of bytes) for that process
» Read moreNVL lets you replace null with a string in the results of a query. Syntax NVL (string1, replace_with) If string1 is null, then NVL returns replace_with. If string1 is not null, then NVL returns string1. Note: The arguments string1and replace_with can have any data type. If their data types are
» Read moreI have tried the Utility WinMerge; it is really helpful for me. Thought it will be handy to all of us, that‘s why sharing with you all. WinMerge WinMerge is an Open Source differencing and merging tool for Windows. WinMerge can compare both folders and files, presenting differences in a
» Read moreColumn Type Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column: Example: Row Type Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or
» Read moreOracle SQL Developer does not display the output of DBMS_OUTPUT.PUT_LINE, it gives “anonymous block completed” in the script output tab Some time we are confused why this is giving message “anonymous block completed” To see the output of script, we need to enable DBMS_OUTPUT by clicking on plus symbol (see
» Read moreOnce you download the Oracle 11 G Release 2 Installer from http://www.oracle.com/technetwork/index.html Click on Setup Files to Start Installing Oracle on your system You need to enter your email id. If you require updated from Oracle. Here we have not given any email id for demo Click “Yes” You can
» Read moreHow to register the certification exams online? Every person who is planning or going for his/her first Certification exam have the same question, that‘s why sharing the global provider of comprehensive testing and assessment services. With the help of these services an candidate can schedule his/her certification exams from home
» Read moreDear and Respected All, I am pleased to announce that yesterday (03-Dec-2011) I have passed the examination of Microsoft Certified Technology Specialist (MCTS): PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 After this exams I have completed certification Microsoft Certified IT Professional (MCITP) : Database Administrator
» Read moreJavaScript is a scripting language for web. In 1995, JavaScript was developed by Netscape Communications Corp. At first, was referred to as LiveScript. Later Netscape decided to change its name to JavaScript because it was more influenced by the Java Programming Language. JavaScript was designed to add interactivity to HTML pages.
» Read moreVarinder Sandhu is using WP-Gravatar