Define external table
it is same as oracle table but act as view to the data available in an external file of a physical drive,so here we can query the data and retrieve and can do anything but cannot do manupulations on the data
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?
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
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.
Oracle commit and commit work
What is the difference between commit and commit work
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...
As such there is no difference operationally. WORK is optional and is provided just for ANSI compatibility.
Multiple row values
How to retrieve multiple row values in a single column
Dear friend, I didn't get exactly what you want,any please tell me the context so that i can help you out................coming to the question:you want the result of multiple rows in a singl...
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
see spool command
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...
Import ms-access tables
How to import tables from ms-access to Oracle?
If you successfully exported the data to text file , then you are very close!
In the export option of Microsoft Access, you shall see an option like "Export to ODBC database". If you click that, you...
This might help someone if need to get table into Oracle from MS Access table.Option-1 - Use MS Access (2003) Export 1. Oracle Client and Oracle ODBC driver should be installed on your PC.2. In O...
Oracle 9i tools and utilities
What is the difference between the tools and utilities in Oracle 9i?
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.
Utility cannot uninstall it is an inbuilt
Tool can uninstall
What is the difference between cold backup and hot backup
Answered by: ttparavindh
View all questions by ttparavindh View all answers by ttparavindh
Member Since Jun-2007 |
Answered On : Jun 19th, 2007
Cold Backup- We can take the Backup while DB(eg. Oracle) is down.Hot Backup-We can take the Backup while DB(eg. Oracle) is running.Cold backup is a physical backup. During a cold backup the database is closed and not available to users. All files of the database are copied (image copy). The datafiles do not change during the copy so the database is in sync upon restore. Used when:Service level allows for some down time for backupHot backup is a physical backup. In a hot backup the database remains open and available to users. All files of the database are copied (image copy). There may be changes to the database as the copy is made and so all log files of changes being made during the backup must be saved too. Upon a restore, the changes in the log files are reapplied to bring the database in sync. Used when:A full backup of a database is needed Service level allows no down time for the backup
Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo...
Cold Backup: Need to back up Database Files, Control Files, Online Redo Log files.Hot Backup: Need to back up Database Files, ControlFiles, Offline Redo Log files (archive files).
Explain few real time scenarios related to deadlock, flashback queries and autonomous transaction
mutation of triggers is an example of deadlock.......for flashback we can use to being tables from recyclebin
Create a query that will display the total no.Of employees and, of that total, the no.Of employees hired in 1995,1996,1997, and 1998. Create appropriate column headings.
WHERE to_char(hiredate,yyyy) in (1995,1996,1997,1998)
GROUP BY Hiredate;
"sql select deptno,count(to_char(hiredate,yyyy),1980,empno) as yr1980,
count(to_char(hiredate,yyyy),1981,empno) as yr1981,
Write a query to display the no.Of people with the same job
select job, count(job) from emp group by job;
CodeSELECT count(*), job
GROUP BY job
What is the difference between rownum,rowid
Answered by: rishipahuja
View all answers by rishipahuja
Member Since Aug-2006 |
Answered On : Aug 6th, 2006
rowid has a physical significance i.e you can read a row if you know rowid. It is complete physical address of a row.
While rownum is temporary serial number allocated to each returned row during query execution.
Row num is a sequential number allocated to each returned row for query execution. It is nothing but a numeric values. It is a temporary values. But row id is a physical address of the rows. It is permanent.
ROWNUM is a pseudocolumn returning a sequential number along with the rows retrieved, whereas rowid (also a pseudocolumn) contains the actual physical address of the data block containing the row
How to apply the generated sequence on the tables?
Say you are using the seq name temp_seq
CREATE SEQUENCE temp_seqStart with 5
Increment by 2maxvalue 999999999999999999999999nocachenocycle
Above will create the sequence temp_seqTo use itINSERT INOT xyz
Dear friend : oracle generate sequence numbers with the help of predefined function called nextval.so if you want insert these generated sequence no you can do using <seq_name>.nextvalfor ...
How to delete duplicate values from tablefor ex: a table contains 200 rows in that 100 rows are duplicate values, how to delete those 100 rows?
Use this simple querydelete from table1 where rowid not in (select max(rowid) from table1 group by duplicate_col_name)
Hi, 'X' refers here to the table name and 'a' and 'b' are the alias nameDelete from X a where rowid in (select min(rowid) from X b &...
Can you explain what is dual table in Oracle ?
Dual is default table in oracle .it contains single row and single column.All the Character functions and number functions and date functions execution done in this Dual table.
Dual is a dummy table which has one row and one column but can't make the DML opertions.
What are SQL complimentary 1999 joins? How can we know whether my Oracle version supports them?
oracle supports two types of joins: 1.oracle joins cartesian join equi join non equi join self join outer join is exhibited ...
Actually we r talking abt the ANSI join syntax,That's available in oracle 9i.this join cannot
be run in lower version means oracle 8i(8.17),oracle 9i releases1.
The join syntax is left outer join,rigth outer join,full outer join.natural join,
Tell me three things about you, which are not found in your resume
What was the most important decision you ever had to make?
Career Options for BCA Graduates
What do you think about our company?
What do you think about continuous learning?
How do you approach a problem?
What are my options when I do not get a job after graduation?
How productive are you?
Tell me about a skill you recently acquired or improved.
Importance of an MBA for an entrepreneur
Ask Interview Question?
Have Career Question?
Ask Only Career questions.