-
What is the difference between bind and declare variable in pl/sql?What is the difference between number,integer, pls_integer and binary integer?
rajakumar_na
- Nov 17th, 2007
One more point Bind variables are declared outside the pl/sql block whereas declare variables are declared with in the pl/sql block
jamesravid
- Jul 18th, 2007
Bind variables are command line parameters.whereas declare variables are variables local variables declared with in the pl/sql code.scope of declare variables is within the procedure you can't use them outside of the pl/sql code. But bind variables are valid till the session is valid
-
What is the command to get the number of coloumns in table
Imran_Javed
- May 13th, 2008
SELECT COUNT(cname)FROM COL c, TAB TWHERE T.Tname = c.Tname AND T.Tabtype='TABLE' AND T.Tname ='EMP';
debasisdas
- Jul 7th, 2007
SELECT COUNT(COLUMN_NAME) FROM DBA_TAB_COLUMNS WHERE table_name = 'TABLE_NAME' AND owner = 'OWNER_NAME' ;
-
How do you decide on whether to use a Procedure or a Function for a particular task ?Is it possible to get the last 10 rows of a table? If Yes How?
jamesravid
- Jul 18th, 2007
For ur second question,select * from (select * from (select col1,col2,rownum as rank ...
jamesravid
- Jul 18th, 2007
I would consider the following points,1. Identify how many variable should be returned by your pl/sql code. If it is only one go for functions else go for procedures.2. Fuctions can be used in ur sql queries whereas procedures can't be used.
-
How SGA works if the user process issuing SELECT statement to the database?
dbashashi
- Jul 14th, 2009
Select statement works in the same way as other querries. The result set is brought from the Datafile if not already in Buffer cache. As we are aware that Buffer cache works on LRU and MRU algorithm ...
kishore.giri
- Dec 12th, 2007
When a query is submitted by the user it comes to the sharedpool and it is processed by the library cache i.e. statement is parsed their,execution plan is prepared and data is retrived from the datafi...
-
How to query data from table which has "GROUP" as column name, since it's keyword?
madhupriya.nukala
- Feb 3rd, 2008
U have to use this gropu as a column by specifiying it in "doublequotes"
madhupriya.nukala
- Feb 1st, 2008
Hi,??? Send me mail if satisfied .Thanks.MadhupriyaSQL> create table string("group" varchar2(20),name varchar2(20));Table created.SQL> insert into string values('&group','&name');Enter value for gr...
-
How to delete user wise data in Oracle 9i?
-
Oracle 9i Tools and Utilities
What is the difference between the tools and utilities in Oracle 9i?
lanka_satya
- Sep 12th, 2008
Utility is something which comes along with software?where it is intended to help us to solve a particular purpose but tool is something which enable us to develop more delebrately we can say as helpful for innovative development.
-
Replace option in Procedure
What will happen if you dont use Replace option in a Procedure when first creating it for first time?
garvi.1983
- Mar 5th, 2008
No problm. It successfully creates the procedure.But once it created ,if u modify it and compail without REPLACE ,it will give an error
-
Time taken by a query
What is the command to print the time taken by a query
hemant.agarwal03
- Feb 13th, 2008
you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time..
karunakaradepu
- Jan 29th, 2008
If UR Q is How TO PRINT A TIME: SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL;
-
Composite Primary Key
WHat is Composite Primary Key?
hemant.agarwal03
- Mar 27th, 2008
Composite primary key used for multiple fields joined together to identify a records in a table. We can use maximum 16 columns for a composite primary key.
ddanda
- Mar 24th, 2008
when 2 attributes of the table form a primary key .such a key is known as composite primary key.
-
Oracle commit and commit work
What is the difference between commit and commit work
lanka_satya
- Jul 4th, 2008
actaully, both mean the same but try to understand what is commit?see..most of the people think that when we type commit data or changes of what you have made has been written to data files,but this i...
panjoshi302
- Apr 29th, 2008
As such there is no difference operationally. WORK is optional and is provided just for ANSI compatibility.
-
Null Memory
How to verify null occupy memory?
nrajakumar
- Aug 15th, 2008
Create table tblNull(col int)sp_spaceused tblNullinsert into tblNull(col) values(NULL)sp_spaceused tblNull
babuda
- Jul 14th, 2008
When we say memory occupy means it is allocated atleast a byte or char or storage space. when we run thisselect null from dual nothing is returned, in my opinion null does not occupy any storage spaceany thoughts? we can think it over
-
Is there any syntactical diff bet Oracle 9i & 10g
Is there any syntactical diff between Oracle 9i & 10g or any change in which the Queries are used....It uses SQL isn't it?
lanka_satya
- Sep 12th, 2008
In 9i we does not have the facility to brign the table that is been dropped, but in 10g we have something like flashback and also in 10g they have added one extra regular expression
meghnshah
- Jul 13th, 2008
In oracle 10g we have new datatype called binary double and binary float. 10 g also has collection api, which allows us to use procedures and funtion with collections. In Oracle 10g external procedures can also be called.
-
AND - OR Operators
In the combination of Logical Operators - AND, OR (more than 2) operators which one gets 1st preference.
-
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;
-
Flow in Oracle Database.
What happens when a query is submitted in oracle? Please give the complete flow as to which all processes act and how the data is submitted / retrieved to / from the database .
-
Oracle Unused Column
How to set unused column back to normal column?
-
Data Dictionary
How can we know the all tables and views that are given for the specific user(such as USER_VIEWS,USER_OBJECTS etc.)?
asit
- Jun 9th, 2012
Data dictionary is nothing but the place holder which contains all information of the object
like name,type,size,owner,permissions etc.
some data dictionaries : user_views,user_mviews, user_tabs, user_sequences, all_objects etcharshljica
- Sep 2nd, 2009
Open dba_objects in that open column name owner, in that mention user name?and it will display the list of tables and views of specific users.
-
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 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.
Oracle Basics Interview Questions
Ans