Ask Anantha

The source for this article can be found in this link: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:516338600346572071   Although this challenge was posted in past, I thought to revive its magic. It was posted by Tom Kyte on Oct 31, 2007 4:52 AM. Without Tom or even AskTom I don’t think Oracle geeks would have some good repository of technical advantage. Here in this article I will rephrase and revive the magic of a small challenge for Oracle geeks. Find out from the following list of versions and features, when they where introduced in Oracle.   Of course you could read the link above and find the same. But try this as an exercise, and you will be surprised (for most of geeks they will find new features, for others they will battle with their memories).   Okay enough for the occasion, here is the features list:   1 Real Application Testing 2 Read only Replication 3 Distributed Query 4 Drop column 5 Client-Server (wh...

----------------------------------------------------------------------- -- Document: Q-quoting mechanism -- Created On: 17-Dec-07 -- Author: Amar Kumar Padhi -- Email: amar.padhi@gmail.com -- Purpose: Q-quote operator introduced in Oracle 10g. -----------------------------------------------------------------------   We make use of single quotation mark in SQL and PL/SQL to identify sting literals. If the literal itself contains a single quote, we need to add one more quote next to it. This additional quote acts as an escape character and removes conflict with the outside quotes that are enclosing the string.   Oracle realises that long complex strings having lot of single quotes can turn out to become cumbersome and prone to errors that may not be caught during testing.   Release 10g onwards, a new quoting mechanism is provided in the form of "q". This new quote operator allows us to choose our own quotation mark delimiter.   H...

In this article we will see how to create queues and to enqueue and dequeue messages. In this article I will not discuss what Advanced Queuing is about and why it is used. This is just a step-by-step guide to generate a message and to read it. The agenda of this article is:   Create a queue table Create a queue Start the queue Enqueue the message Dequeue the message   Create a queue table --Type to hold the item object create or replace type aqt_item as object (item_id number , item_description number ) ; --Type to hold order object create or replace type aqt_order as object (order_id number , ord_name varchar2 ( 60 )) ; exec DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'aqt_queue_table', queue_payload_type => 'aqt_order');   Now we will see what are the objects created.   SELECT queue_table ,type,object _type,recipients FROM USER_QUEUE_TABLES;   QUEUE_TABLE   ...

For this comment in : http://askanantha.blogspot.com/2007/11/download-oracle-11g.html post, I could not reply due to some technical difficulties. Find my answer in this post: The question was: Im a student and while creating the account in the oracle site its asks for office name...what should I write? While creating the user you specify your role as Student. You can enter any name for the company. Oracle might have to think again for this question. Cheers. Anantha

Oracle’s new database offering 11g is released and is available for download: Click here to download 11g Release 1 (Size 1.7 GB) Oracle Database 11 g Release 1 (11.1.0.6.0) Standard Edition, Standard Edition One, and Enterprise Edition Microsoft Windows (32-bit) (1.7 GB) | See All (Including Client, Examples, Gateways, Clusterware ) Microsoft Windows (x64) (1.7 GB) | See All (Including Client, Examples, Clusterware ) Linux x86 (1.7 GB) | See All (Including Client, Examples, Gateways, Clusterware ) Linux x86-64 (1.8 GB) | See All (Including Client, Examples, Gateways, Clusterware ) Solaris (SPARC) (64-bit) (1.9 GB) | See All (Including Client, Examples, Gateways, Clusterware ) AIX (PPC64) Disk 1 , Disk 2 (2.3 GB) | See All (Including Client, Examples, Gateways, Clusterware ) HP-UX Itanium Disk 1 , Disk 2 (2.3 GB) | See All (Including Client, Examples, Gateways, Clusterware ) You will be asked with your otn login. It’s free to sign-up. Follow the bel...

Mini Tip: Running 10gAS forms in MDI Window Author: Anantha Narayanan Date: November 6 th 2007   Those who have been migrating from Oracle Client Server forms would have always wondered why the 10g forms are running always inside a browser. They probably know the reason of such behaviour.   In today’s mini article we will see how to change the default behaviour of 10gAS forms back to client server mode. If you have installed 10gAS in your local machine then there is no problem of access rights. If this is installed in some server and you do not have access to that machine, then forget this setting, because we need to modify the default server settings.   Locate the file formsweb.cfg (for default installations) (its default location will be in <AS_INSTALLATION_PATH>\forms\server and find out a parameter named separateFrame. This is a Forms applet parameter. These parameters are used to initialize the forms applet.   Modify the valu...

The LIKE-clause can ignore indexes, causing queries to run forever while doing full table scans. This document describes how to tune such SQL statements by making use of Oracle Text or reverse key indexes . Tuning the ‘LIKE’ Clause: Generally, search arguments in the WHERE clause such as "IS NULL", "<>", " != ", "!>", "!<", "NOT", "NOT EXISTS", "NOT IN", "NOT LIKE", and "LIKE '%500'" prevents Oracle from using an index to perform the search (however, not always). If you use LIKE in your WHERE clause, try to specify one or more leading characters if at all possible. For example, use LIKE 'm%' and not LIKE '%m'. If you specify a leading character, Oracle has a better chance of being able to use an index to perform the query - this will increase performance and reduce the load on the database server. To avoid such full table scans, consider the follo...