Hi,
Oracle will definitely throw an error if the sequence exceeds the max value & cycle parameter is not set.
The error will be ORA-08004,
ORA-08004: sequence SEQ_TEST1.NEXTVAL exceeds...
Type: Posts; User: Innila; Keyword(s):
Hi,
Oracle will definitely throw an error if the sequence exceeds the max value & cycle parameter is not set.
The error will be ORA-08004,
ORA-08004: sequence SEQ_TEST1.NEXTVAL exceeds...
Hi Suresh,
umask value can be derived by adding up the permissions for the category & then subtract the value with 7.
It will be clear with an example,
The value for read, write & execute...
Hi Suresh,
Let me first understand your question...
If the Benefits columns has multiple records like below,
BENEFITS
----------------
LOW
MEDIUM
HIGH
Hi,
Probably the listener was not running.
Start the listener using "lsnrctl start" command in Unix and if its Windows OS start the listener service.
If the listener is running & still u have...
Hi,
Since the definition alone is not very much clear, let me explain with an example in detail.
As already given, Setting termout is used to display or suppress the output of sql commands if the...
Hi Bharani,
Use your query as follows,
select empno, empname from empl where empname like '%'||v_empl||'%';
This way you can use the input variable inside the like condition.
Hi Barbie,
I just have a small doubt reg the types of views which u have mentioned. Are they types of view of Oracle Database? :confused:
As far as i know there are 2 types of views in Oracle,...
2) what is 'set termout on' ?
Setting termout is used to display or suppress the output of sql commands if the commands are run as a sql script.
For example, if "set termout off" is given, it will...
Hi vmshenoy,
Checked out the Oracle OTN site, if u want to go for Oracle 9i or 10g version, the database downloads are available.
I'm not sure about the download conditions for 9i, but very sure...
Hi Purna,
Use this query,
SELECT cust_name FROM CUSTOMER
WHERE cust_id = ID;
ID is the passed textbox value.
Oh! vmshenoy will be happy to hear that :-)
Barbie, the installation was fine & is it working fine?
Hi vmshenoy,
In Hostname, enter the Machine ID on which the oracle is been installed.
TNSNAMES.ORA is very important for the database connectivity.
A tnsnames.ora file provides the ability...
Hi Anand,
Formatting the Query results will satisfy your above format & the query is,
break on deptno skip 0
select deptno, empno, ename
from emp
order by deptno
Rowid function is invalid in SQL Server.
Rowid is the best way to eliminate duplicate records in Oracle & in SQL Server, the distinct function can be used.
Hi aardvax,
Its a nice idea to discuss about DBA activities. :cool:
I think copying the data files is the fastest recovery method than importing the tables into the database.
Hi aardvax,
Physical structures are those files which are physically present in the Hard disk (physical space).
Datafiles, control files, Redo log files, Archive log files, parameter files, etc...
Hi,
Using Case Manipulation functions (Upper, Lower, Initcap) will be more appropriate for this validation.
Hi Reeta,
I think the Geekinterview site will be very helpful, which has so many interview questions.
Try this,
Oracle Interview Questions
All the very Best !!!
Yeah true.
Nice that u have mentioned the correction, James.
Hi Chitra,
A subquery is a select statement that is embedded in a clause of another select statement.
A subquery is a SELECT query that returns a single value and is nested inside a SELECT,...
Hi sudha,
U can go for the following books for oracle 9i 1z0-007 exam,
1) OCP Introduction to oracle9i: SQL exam guide by Jason Couchman
2) OCA/OCP: oracle9i DBA fundamentals i study guide by...
Hi Rohit,
Cant u update the row instead of creating a new table?
What is the Oracle version your using?
Hi Rohit,
Since u arent able to use abs function in a varchar column, then try converting the varchar into number & then identify the absolute value,
The column ENO has a varchar2 datatype...
Hi Saravanan,
Data consistency means the validity & accuracy of the data available in the database.
The consistency of the data is identified by the relevant changes made by the user's...
I believe this command wont work in Oracle database.
If im right, i think this command is compatible in MySQL database. Probably bvani can clarify regarding this.