Latest Answer: Length function is meant to return the length of the string.length('abc')=3 vsize returns the size of the oracle datatype in bytes.vsize('abc') = 3 as character occupies 1 byte. ...

Read Answers (1) | Asked by : kehri_anurag

Answer Question Subscribe

How to determine the objects approaching max extents.

Latest Answer: a simple query which tells objects reaching maxextentssql> select segment_name,segment_owner from dba_segments where max_extents-extents=0; ...

Read Answers (2) | Asked by : sszssz

Answer Question Subscribe

How can we go on reverse normal form? i.e. suppose a table is in fifth normal form, so how can we convert

How can we go on reverse normal form? i.e. suppose a table is in fifth normal form, so how can we convert it into first normal form?

Read Answers (1) | Asked by : sachinp1979

Answer Question Subscribe

Describe the principles of OOPS in Oracle.

Latest Answer: In Oracle with PLSQL language implemented in D2K, we can use principle of INHERITANCE by using Libraries which is oops concept. ...

Read Answers (1) | Asked by : skmishra_it

Tags : OOPS

Answer Question Subscribe

What is Snapshots in SQL ? why these are used ?

Latest Answer: Snapshots are the portion of database. Similar to views ...

Read Answers (2) | Asked by : skmishra_it

Answer Question Subscribe

What is use of variable declartion in programming language?what is difference between oracle & programming

What is use of variable declartion in programming language?what is difference between oracle & programming language?

Read Answers (2) | Asked by : senthil

Answer Question Subscribe

What is the difference between temp file and data file?

Latest Answer: 1)Database can be opened without tempfiles in the temporary tablespace.2) Tempfiles can't be renamed.3)Tempfiles doesn't need recovery.4)Segments in temporary tablespace are dropped when no longer required. ...

Read Answers (2) | Asked by : innovative

Answer Question Subscribe

Can we write a cursor without select statement

yesIn Package

Latest Answer: In reference cursor but we have option of giving the where clause in the body ,We cann't write cursor without select statement. ...

Read Answers (1) | Asked by : rajeevsingh

Answer Question Subscribe

What are the recommended size for initial and next for temporary table space to reduce fragmentation?

View Question | Asked by : balu

Answer Question Subscribe

What is the maximum size of the control file

Latest Answer: The size of controlfile depend on 5 different parameter at the time of creation of database.MAXLOGFILEMAXLOGMEMBERSMAXDATAFILESLOGHISTORYMAXINSTANCE. ...

Read Answers (1) | Asked by : balu

Answer Question Subscribe

View page << Previous 1 [2] 3 4 5 6 7 Next >>

Go Top

#	User Name	Count
1	innovative	9
2	sumitwatal	6
3	mala321	6
4	skmishra_it	6
5	kumaresan.m	5
6	akshaykb1	4
7	oraclewannabe	4
8	daulat	3
9	camafla	3
10	kunal1017	3

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX