-
Send SQL* Plus session output to text file
How do you send the output of your SQL* Plus session to a text operating system file
lanka_satya
- Jul 4th, 2008
well you want to see the output ina text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spoo...
-
Data Integrity
How does Oracle guarantee data integrity?
kperumal75
- May 4th, 2011
Data Integrity is maintained by Triggers and various other constraints in Oracle.
kperumal75
- May 4th, 2011
Oracle Database enables you to define and enforce each type of data integrity rule defined in the previous section. Most of these rules are easily defined using either integrity constraints or datab...
-
Catch The Error
SQL>DECLARE 2 dayofweek VARCHAR2(200); 3 BEGIN 4 SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL ; 5 6 IF dayofweek = 'Tuesday' 7 THEN 8 DBMS_OUTPUT.PUT_LINE('Aloha!!! Today Is Tuesday'); 9 ELSE 10 DBMS_OUTPUT.PUT_LINE('Today is '||to_char(sysdate,'Day')); 11 END IF; 12 END; 13 /Today is TuesdayPL/SQL procedure successfully completed.SQL>What's...
-
Locking a User from performing DML Operation
Which command is used for locking a user from performing DML Operation?
karthikasathya
- Oct 1st, 2009
LOCK TABLE tablename IN EXCLUSIVE MODE;EX:LOCK TABLE emp IN EXCLUSIVE MODE;
-
Convert Report to Text File
How to convert Oracle Report into text or doc file?
-
Stored Procedure Debugging
How to debug stored procedure in Oracle?
budzboy
- Jul 14th, 2010
You may use dbms_output.put_line([string]) between lines you think causes the error.
-
Show Busy Cursor
How to show the cursor is busy when any process is going on in Oracle Forms 6i?
-
How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ?
sunnybhattacharjee
- Jul 7th, 2010
You can store a jpeg file or a bitmap file in Oracle using the BLOB data type.It stores the jpeg image as a stream of bytes.In order to retrieve the data.You cant simply perform a select query over it...
sudheer
- Oct 6th, 2006
To store larger object in database use 'blob'
-
Base Table Update
How to update base table (data dictionary) automatically in every 5 sec or 5 min?
monika_iims
- Jun 18th, 2010
1.create a procedure with update statement2. create a job on that procedure and give the time interval
-
Sequence and Indexes
When do we will go for Sequence and when go for Indexes. What is the difference between Sequence and Indexes.
varunprasath
- Jun 7th, 2010
Sequence - A sequence is used to generate a number sequence that can be used as a primary key.Indexes - An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.
-
Dictionary Management Tablespaces
How will you change the local management tablespaces into dictionary management tablespaces?
-
Dynamic SGA
What is Dynamic SGA?What is the advantage of Dynamic SGA?
hmounir
- May 3rd, 2010
Dynamic SGA allows to change the size of the buffer cache, the large pool, the shared pool and the process private memory on the fly, that is without shutting down the instance.
doza_kasf
- May 1st, 2010
Dynamic SGA allows to change the size of the buffer cache, that is without shutting down the instance.
-
Tablespace Fragmentation
How can you prevent tablespace fragmentation? (rebuilding, moving)?
vidyajnath
- Apr 23rd, 2010
As rows are added to tables, the table expands into unused space within the space. Conversely, when rows are deleted, a table may coalesce extents, releasing unused space back into the tablespace. As ...
-
Chained / Migrated Rows
Explain about the Chained / Migrated Rows
vidyajnath
- Apr 23rd, 2010
In two circumstances, the data for a row in a table may be too large to fit into a single data block. In the first case, called chaining, the row is too large to fit into an empty data block. In this ...
-
Oracle Background Processes
Outline the names and function of Oracle background processes
vidyajnath
- Apr 23rd, 2010
The Oracle architecture has five mandatory background processes Mandatory background processes: DBWR (Database Writer) PMON (Process Monitor) CKPT (Check Point) LGWR (Log Writer) SMON (System Monitor)...
-
Oracle Segments
What are the different types of segments in Oracle?
hmounir
- Apr 21st, 2010
Four types of segments are found in an Oracle database:1- Data segment every table in the database resides in a single data segment.2- Index segment each index is stored in its own index segment.3- Te...
narendra05
- Apr 16th, 2010
There are following types of segments in Oracle1. Data segments stores the data2. Index segment stores the index data3. Rollback segment : Stores undo data information for data consistency.
-
Acid Properties
What is Acid Properties in Oracle?
ushaudayam
- Mar 22nd, 2010
ACID Properties areAtomicity: A transaction is an atomic unit of execution, which may contain more than one database operation. The transaction should be done entirely or done nothing to keep data in ...
-
Oracle Dbms Pipe Commands
Give the dbms_pipe commands in oracle of there execution,which are used to send & recieve messages what is the max size can sent at one go
Read Best Answer
Editorial / Best Answer
saginandkishore- Member Since Jun-2008 | Jun 24th, 2008
dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes.
The important functions/procedures in this package are
(1) CREATE_PIPE to create a new pipe
==> dbms_pipe.create_pipe(pipename) where pipename can be Oracle supplied or user defined as below
dbms_pipe.create_pipe(dbms_pipe.unique_session_name) -- Creates a PIPE based on your unique Session ID
or
pipename constant varchar2(100) := 'TEST_PIPE';
dbms_pipe.create_pipe(pipename);
(2) Having created the pipes try sending some data through the pipe. To send data prepare the data using dbms_pipe.pack_message(mesg_buf) where mesg_buf can be varchar2, char, number. Basically this procedure is overloaded for Numbers, Varchar2 and date. For long and raw data use the corresponding DBMS_PIPE.PACK_MESSAGE_RAW method. This procedure basically places the data into buffer which can be send on any pipe using the dbms_pipe.send_message(pipename) function.
(3) At the other end of the pipe you can receive the data using dbms_pipe.receive_message function. This functions fetches the data into buffer from where you can unpack the data using dbms_pipe.unpack_message function. This function gets the data in the buffer into a message buffer.
These are the basic commands that you can use for working with pipes. For more details visit oracle documentation.
imranbaig.geek
- Dec 1st, 2009
------Funtions------DBMS_PIPE.CREATE_PIPE:- for creating a pipeDBMS_PIPE.SEND_MESSAGE:- For sending messageDBMS_PIPE.REMOVE_PIPE:- for removing messageDBMS_PIPE.RECEIVE_MESSAGE:- For receiving message...
saginandkishore
- Jun 24th, 2008
dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes. The important functions/procedures in this package are(1) CREATE_PIPE to create a new pipe ==> dbms...
-
Oracle Unused Column
How to set unused column back to normal column?
-
Recover data from database block corruption error
How to solve the database block corruption error? even index also validated and recreated and don't have any backup.
Oracle Basics Interview Questions
Read Best Answer
Ans