-
What is the advantage to use trigger in your PL?
bhagya
- Feb 10th, 2012
1.Auditing the tables
2.Online transaction
3.Securing from another table
4.Automatic calculations
5.Replicate the tableschennoju
- Aug 3rd, 2006
The main advantages of the triggers are* To Audit the table* To check the complex conditions which are not possible by the constraints.
-
-
-
How to retrieve the 2nd record from a table ?
How to retrieve the 2nd record from a table which has say 1000 records in it. Please answer this without using the row-id? I tried to say a query "select * from table where rowcount=1" which worked well and also "select * from table where rowcount=3" which gave me the result but not when I did the same query "select * from table where rowcount=2" ? why?
rima
- Nov 24th, 2011
Code- SELECT * FROM `table_name` WHERE rownum <> 1 ORDER BY rownum ASC LIMIT 1;
smonroy
- Sep 27th, 2011
The best way to issue is
select top 1 * from cars where id_car in
(select top 2 id_car from cars order by id_car)
order by id_car DESC
and with that
obtain the second record (This way is for the PK) -
How to delete identical row from a table?
how to delete identical row from a table?
if we have 4 row and two of them having same data then how we delete identical row using delete querySiraj
- Oct 15th, 2011
Delete from table_name where rowid not in (SELECT max(rowid) FROM table_name group by (column_name))
-
How many tables are needed to create and their relationships ?
Supplier Name
Supplier Site
Supplier Street
Supplier Contact Person
Supplier City
Supplier State
Supplier Phone number
Business requirement is : One Supplier can have multiple ( n number of
Sites ), One Supplier Site can have Multiple Contacts Persons ( n
number of Contact persons ), One Supplier Contact Person can have
multiple phone...ashadevi21
- Oct 5th, 2011
Supplier Table Columns : Supplier id , supplier name (Supplier ID, supplier name as Primary Key) Supplier Site Details Columns : Supplier name , site, street, city, state (Supplier name as foreign Ke...
-
Inner join and Outer join
What is the difference between inner join and outer join?
Mark Haynes
- Sep 30th, 2011
First to define what Inner Join and Outer Join mean. Inner Join: A join between two tables were only those records in both tables that meet the conditions of the join expression are returned. In most...
-
Employee Query question
Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field..
-
HAVING Clause
Given a SELECT statement that has a GROUP BY clause.The HAVING clause uses the same syntax as which other clause?A. WHEREB. UNIONC. SUBQUERYD. ORDER BY
Ksudhir_Kumar
- Sep 5th, 2010
Having clause is used filter data which is retrieve by group by clause.for example: if you try to use having to filter data instead of where clause then it fires error.the style of query is:- 1...
-
INSERT Statement Optimization
A script is inserting data into one table, it was taking 15 min to complete before. Today it is taking more than 2 hours. What kind of action you will take?
smonroy
- Sep 28th, 2011
Also you can do the below steps
1.- Normalization your DB
2.- Break the INSERT in some INSERTs instead have one
3.- You need to create indexes on the tablearindam_0006in
- Aug 11th, 2010
Do not paste in sql client and run the script. Use sql administration console. First analyze it and browse the sql dump file and execute it. Think there will be no issue.
-
Remove redundant rows
How to remove redundant rows without any distinct columns in the table itself ?
smonroy
- Sep 27th, 2011
Hi my Friend this is the best way to you issue DELETE FROM table_name where camp1 in (SELECT camp1 FROM table_name GROUP BY camp1 HAVING Count(camp1)>1) Example: DELETE FROM ubication where serial...
Allan Hunter
- Sep 22nd, 2011
You're question is vague, but from what I understand it to mean is to remove duplicate rows wihle keeping the columns in tact. The easiest way I know is to make your query based on what makes the dat...
-
LOB Segment
What do you mean by LOB segment? Explain LOB segment
smonroy
- Sep 27th, 2011
You are talking about oracle, LOB is simply a pointer. It points to an index.
-
-
What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features&advantages in Oracle and MS Access?
Jee Va
- Sep 17th, 2011
Hi! everyone, I've to develop a small retail store management application for our Store. I've selected the front end as JAVA and back end is ??? (Still confusing) to use 1.Using File Handling(but i do...
ywaikar
- Jul 17th, 2009
Both Oracle and MS Access are RDBMS, Oracle followed Client-Server architecture while MS Access is does not.We can have Login Security, command level security in Oracle.Can define relationship at time of table creation.
-
What is the use of Parametric Cursor ?
dinesh.smhdr
- Sep 13th, 2011
"oracle8 declare cursor c_emp (cin_No NUMBER) is select count(*) from employee where id = cin_No; v_deptNo employee.id%type:=10; v_countEmp NUMBER; begi...
-
What is the main use of FOREIGN KEY?
Read Best Answer
Editorial / Best Answer
Answered by: MANAS KUMAR ROUT ( USA ) (TCS) (Eli LILLY ) - PFIZ
- Jul 6th, 2007
Hey Ramesh,
I understand your interviewer's enthusiasm to know about the Foreign Key.? See foreign key definitions says its states the relationship of one attribute(Column) of one table to the corresponding column on the other table.
So one os a parent and other is child. PARENT is that table which holds the primary key and CHILD is table which holds the referential key. Hence every entry in the PRIMARY table is unique where as same entry might be repeating in the child table. BUT that same has to be present in the PARENT table (Primary KEY).
Now Going by definition Foreign key can be of two types :
========================================
1.? ON DELETE SET NULL
2.? ON DELETE SET CASCADE
DETAILS:
=======
On delete set null :
=======
When a foreign key is created by on delete set null definition then when you delete one row from the primary?column (of parent table ) , then the corresponding entry in the foreign key table (Child table ) have the value "NULL" for that particular column.
ON Delete Set Cascade:
================
When the foreign key is created by this definition then when you delete the primary column (any one row -unique data) , then the Child table forcefully deletes all the rows in the child table having same value for that particular column.
I hope u got the crux of the Foreign key
Thanks
Manas Kumar Rout
SAS Consultant
Oracle Certified Associate
Unix Consultant
shweta dhumal
- Sep 8th, 2011
foreign key is primary key of other table. for example: 'STUDENT' is one table which stores information about students and 'SID' is primary key in that table and 'MARKS' is another table which stor...
shweta dhumal
- Sep 8th, 2011
The purpose of the foreign key is to ensure referential integrity of the data. In other words, only values that are supposed to appear in the database are permitted. For example, say we have two tab...
-
DROP command and VIEW
How does dropping a table affects its view?
sivaraj6389
- Sep 7th, 2011
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Table Name'.
Msg 4413, Level 16, State 1, Line 1
Could not use view or function 'view Name' because of binding errors. -
What operator performs pattern matching?
saurabh
- Sep 5th, 2011
Underscore operator (_) for single character matching n wildcard (%) for any length string matching...
example a column having abhi,abhaaa, bhaaa,bmddd,cmmm;and i want all those name that start with a then use like 'a%'; -
What is Dual table?
What is dual table which is used as a table in sql...
Read Best Answer
Editorial / Best Answer
svsraju81- Member Since Jul-2008 | Jul 24th, 2008
Dual table is a temporary table, it contains a single row and single column. If we return a data from dual table it gives a single row.
sudipta kumar dhal
- Sep 5th, 2011
Dual table is called a dummy table because it is not meant for storing any useful data.
d_pranjal
- Sep 5th, 2010
Dual table is owned by SYS. Data dictionary come under SYS, dual is part of data dictionary. Dual table consist only one row and only one column containing value x
-
Inserting the image
How can I insert an image into oracle database?
SQL Interview Questions
Ans