-
Meaning of I and G in Oracle Versions
What is the meaning of I and G in Oracle 9i & 10g versions
poonam192005
- Nov 2nd, 2010
Meaning of i in ORACLE 9i is INTERNET and meaning of g in ORACLE 10g is GRID COMPUTING
-
How do you subtract two columns in oracle database
How do you subtract two columns in oracle database, two columns are in data format.Example : inserttime column senttime column?
pravesh28
- Nov 28th, 2010
select to_date(insertime,dd/mm/yy)-to_date(sentime,dd/mm/yy) as date_differnce from table_name;
rkh_301
- Aug 12th, 2010
If the fields are defined as TIMESTAMP type, you could do something like below. In this query, the startdttm and enddttm fields are defined as TIMESTAMP type:select phasename, stepname, enddttm-startdttm as Elapsed from psupgstatuswhere runname = 'dlm_v4d_b018';
-
If we truncate a table which consists of 100 rows then how many rows get updated?
prititripathi
- Oct 7th, 2011
Truncate teablename
used to delete the table
it will not update any row of the tablepravesh28
- Dec 28th, 2010
100turncate coomand delete all the row without deleting the colomn so 100 row updated......
-
Create View
Write an SQL statement to create views.
-
SQL Query email automation
How do I write a cron which will run a SQL query and mail the results to a group?
Kwisatz_Haderach
- Feb 1st, 2011
Create sql file name_of_file.sqlIn name_of_file.sql file output to pipe 'mailx -s "SUBJECT" mail_recepient' select * from table;Create a unix script name "whatever&q...
Kalyan
- Oct 18th, 2005
Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results throught email.
-
SQL Except Using Cast
Discuss Except using cast like type cast. (Question in the context of difference between two tables)
-
To access Excel data into sql
Dear All,Suppose i have Excel table and within that i have some records. Please tell me the SQL query so that i can create table and populate the Excel sheet data
-
Which date function is used to find the difference between two dates?
MONTHS_BETWEEN
Mahesh Deore
- Mar 16th, 2011
This is the inbuilt funcion of Sql server that gives you the difference between two diffrent dates as days "dd", month "mm" and year "yyyy" also at the place of formate s...
HussainExpect
- Nov 20th, 2008
In SQL 7.0, 2000Select days=datediff(dd,'1-1-2008','1-31-2008')Result 30 days
-
Delete distinct name from table
How could i delete the distinct name from the table. the rest record would be available as it is in the table?
pravesh28
- Nov 28th, 2010
delete from table_name where column_name in (select distinct(column_name) from table_name);
preethi
- Jan 9th, 2007
To remove distinct rows from a table use thisdelete from table_name where column_name in (select distinct(column_name) from table_name);If u want unique values select distinct (column_name) from table_name ;
-
Recent row entered
I have a very unusual question, how can one check which is the recent row added to a table?
Read Best Answer
Editorial / Best Answer
biswaranjanbehera- Member Since Jul-2008 | Aug 6th, 2008
We can select the recent row enrtered by using the query below.
suppose the table name is employee;
then.
select * from employee where rowid=(select max(rowid) from employee).
This works fine because rowid is assigned for each and every record and in accending order. So the recent record's rowid is the man (rowid). Please send feedback with any concern.bulat
- May 31st, 2010
"Although a rowid uniquely identifies a row in a table, it might change its value if the underlying table is an index organized table or a partitioned table." Also rowid stores information a...
dachi316
- Aug 26th, 2009
SCOPE_IDENTITY() would be a better option to get the most recently added row as the primary key for a table may not necessarily be an auto-incrementing variable. Therefore max(rowid) would not be the optimal solution in that case.
-
How to retrieve record number 70 from a table of 100 records?
krishna
- Sep 26th, 2006
select * from emp where rownum<71minusselect * from emp where rownum<70;
-
Pairwise and Non-Pairwise Comparisons
Explain the difference between pairwise and non-pairwise comparisons in multiple column sub-queries.
pravintule
- May 28th, 2010
In pairwise comparison the attributes included in where clause predicate are compered in same predicate and only single predicte is evaluated.where as in non-pairwise comparison the attributes are com...
yogesh.raut
- Mar 13th, 2010
Pairwise means we can put two checks at a time using subquery using ' in ' condition.. Non pairwise mean seprately we have to specifiy subquery for both conditons using equality operator.
-
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language (DDL)
-
Command to show SQL commands from buffer
Which command displays the SQL command in the SQL buffer, and then executes it?
sandeep.katta
- Feb 3rd, 2011
RUN Command...... Check by following exampleSQL> select sysdate from dual;SYSDATE---------03-FEB-11SQL> run 1* select sysdate from dualSYSDATE---------03-FEB-11
hemant.agarwal03
- Mar 17th, 2008
LIST and L is correct but you can also type "ED" also on sqlplus window and enter, it will open a notepad window for you to edit (if you required) otherwise you can press ALT + F4 and ENTER key.
-
Correlated sub-query and nested sub-query examples
Please give some sub-query examples based on correlated sub-query and nested
Pallavi g rao
- Apr 21st, 2011
correlated:- outer query is executed first and result is sent to inner query for execution select * from emp e1 where e1.basicsal=(selcte max(basicsal) from emp e2 ...
nandlalseth
- Aug 14th, 2008
Correlated Sub Query:Select * from emp e where exists (select 1 from dept d where d.deptno?= e.deptno)Nested Sub Query:Select * from emp e where deptno in (select deptno from dept d)
-
What is the use of CASCADE CONSTRAINTS?
When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.
jpundalik
- Dec 30th, 2009
This is used enforce the constraints to delete the chaild records when corresponding parent records are deleted.This can be explained with below example- Parent table has department details creat...
Thanagdurai
- Jul 25th, 2007
Hi,Deletes all Foreign keys that reference the table to be dropped, then drops the table. RedsTahngam.
-
There is a Eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with M and M with F?
CREATE TABLE temp(eno NUMBER CONSTRAINTS pk_eno PRIMARY KEY,gender CHAR(1) CHECK (gender IN( 'M','F')));INSERT INTO temp VALUES ('01','M');INSERT INTO temp VALUES ('02','M');INSERT INTO temp VALUES ('03','F');INSERT INTO temp VALUES ('04','M');INSERT INTO temp VALUES ('05','M');INSERT INTO temp VALUES ('06','F');INSERT INTO temp VALUES ('07','M');INSERT INTO temp VALUES ('08','F');COMMIT;UPDATE temp...
Elena
- Nov 8th, 2007
Update set gender=(case gender when 'F' then 'M' when 'M' then 'F' end)
-
Import & Export Through OEM & SQL
Can any one guide me how can i import and export schema using SQL and OEM
luzaolai
- Apr 27th, 2009
In db2 three different format (ixf,del,asc) to export data:Export to tablename.ixf of ixf select * from tablename. When do import we can define if the original data should be kept or cleaned. Insert ...
-
Single Row Function
Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same
yuvaevergreen
- Jun 8th, 2011
In Teradata,sel * from employee where substr(name,1,1)=substr(name,length(trim(name)),1)
Miao Lin
- May 9th, 2011
SELECT * from employee where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);
-
SQL Query to return only duplicate rows and count
I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated?
yuvaevergreen
- Jun 14th, 2011
sel name,count(*) from retail.yuvagroup by 1 order by 2 having count(*) >1
SQL Interview Questions
Read Best Answer
Ans