- Which type of lobs cannot be declared as temporary?
-
Asked By: Interview Candidate on: Oct 2nd, 2004
Which type of LOBs cannot be declared as temporary?
Last Updated on: Oct 31st, 20211 answer
- Cursor for loop and open, fetch,close
-
Asked By: keerthi on: Jan 26th, 2019
Cursor for loop and open, fetch,close
What is the difference of using cursor for loop and open,fetch,close. Which one is better? Both are giving same output
Last Updated on: Jan 26th, 20190
- Pct free and pct used
-
Asked By: sakshigopal on: Jul 24th, 2010
PCT Free and PCT Used
What is PCT free and PCT used?
Last Updated on: Oct 19th, 20181 answer
- Error while inserting records into table
-
Asked By: Sudhakar on: Dec 26th, 2017
Error while Inserting Records into Table
How to insert records into Oracle db table if I got error while inserting 4th record then how to insert 5th,6th.... records continuously
Last Updated on: Sep 11th, 20181 answer
- Find high value of an array
-
Asked By: mahesh on: Dec 27th, 2017
Find High Value of an Array
How to find out the max high value using varray?
Last Updated on: Jan 23rd, 20181 answer
- Use of nocopy in procedure
-
Asked By: Prajakta on: Dec 2nd, 2017
Use of NOCOPY in Procedure
CREATE OR REPLACE PACKAGE XX14_SO_INBOUND_PKG AS PROCEDURE main ( x_errbuf OUT NOCOPY VARCHAR2 , x_retcode OUT NOCOPY NUMBER , p_data_file_path IN VARCHAR2 ); END XX14_SO_INBOUND_PKG; In above procedure what is the use of NOCOPY...?
Last Updated on: Jan 12th, 20181 answer
- When I type 'ed' or 'edit' in Oracle I did n't presented by any...
-
Asked By: haisubbu on: Feb 25th, 2006
when i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem?
Last Updated on: Dec 14th, 201712 answers
- Which one is faster delete/truncate? Why?
-
Asked By: SaratKumar on: Oct 10th, 2005
Which one is faster DELETE/TRUNCATE? Why?
Last Updated on: Nov 27th, 201735 answers
- Synonym without table
-
Asked By: Meera on: Oct 18th, 2016
Synonym without Table
If there no table but we can create a synonym. If it raises error or not. If raises error what error it raises.
Last Updated on: Nov 11th, 20174 answers
- What is the difference between ref cursor & normal cursor?
-
Asked By: SaratKumar on: Oct 10th, 2005
What is the difference between REF Cursor & Normal Cursor?
Last Updated on: Oct 27th, 201722 answers
- Cursor and bulk collect
-
Asked By: vadivel on: Mar 17th, 2017
CURSOR and BULK COLLECT
How does CURSOR and BULK COLLECT work logically?
Last Updated on: Aug 2nd, 20172 answers
- Refcursor data type
-
Asked By: vadivel on: Mar 17th, 2017
refCursor Data Type
When and for what purpose do we use refcursor instead of other data type?
Last Updated on: May 30th, 20171 answer
- PL/SQL block cursor
-
Asked By: vadivel on: Mar 17th, 2017
PL/SQL Block Cursor
Scenario: I forgot to Close the Cursor in PL/SQL block. I executed the block successfully. Again I am going to execute that block without Closing the cursor. An error will be thrown or not?
Last Updated on: May 15th, 20171 answer
- Number of databases running
-
Asked By: renjithmadhavan on: Sep 1st, 2009
Number of Databases Running
How do you verify the number of Databases running on a Host?
Last Updated on: May 8th, 20173 answers
- Truncate vs delete
-
Asked By: Srikanth on: Nov 20th, 2016
Truncate Vs Delete
If a table contains 2 million rows, consider the below scenarios? - DELETE command to delete just few rows in a 2 million row table. - TRUNCATE command (will obviously deletes 2 million rows) Which is faster. Truncate or Delete?
Last Updated on: Jan 28th, 20171 answer
- Tablespace management autoextend option
-
Asked By: guru on: Mar 16th, 2016
Tablespace Management Autoextend Option
Is it possible to autoextend on option for two datafiles of same tablespace? How?
Last Updated on: Aug 9th, 20161 answer
- What is blender in Oracle hyperion drm?
-
Asked By: sakshi on: May 8th, 2015
What is Blender in Oracle Hyperion DRM?
Last Updated on: Feb 22nd, 20161 answer
- Export and import
-
Asked By: pradeep on: May 5th, 2015
Export and Import
What is the use of IGNORE option in the Export and Import?
Last Updated on: Jul 30th, 20152 answers
- How the bitmap indexes can be useful for fact tables ?
-
Asked By: Ram on: Jul 20th, 2007
How the Bitmap indexes can be useful for Fact tables ?
Last Updated on: Apr 28th, 20152 answers
- Multiple database access one instance
-
Asked By: God Father on: Mar 8th, 2015
Multiple Database access one Instance
Can Multiple Database access one Instance ? Yes or No ? Explain
Last Updated on: Apr 23rd, 20151 answer
Copyright © 2022 GeekInterview.com | All Rights Reserved
