-
SQL Except Using Cast
Discuss Except using cast like type cast. (Question in the context of difference between two tables)
-
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.
-
Create View
Write an SQL statement to create views.
-
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......
-
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';
-
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
-
Query to find amout of salary hike
In table "salary" with emp_no,sal_dt,salary which records salary of all employees every month.find the query to give the amount of salary hike and date of hike for all the employees.
ngiridhar
- Oct 26th, 2010
SELECT empno,
DECODE (SIGN ( salary
- LEAD (salary, 1, 0) OVER (ORDER BY empno DESC,
sal_dt DESC)
),
-1, 'LAST',
salary
- LEAD (salary, 1, 0) OVER (ORDER BY empno DESC, sal_dt DESC)
) AS sal_diff
FROM salaryramkrishnag
- Oct 17th, 2008
Select distinct S1.empno , s2.sal_date , (s2.sal-s1.sal) Salhike from salary s1 , salary s2 where s1.empno = s2.empno and (s2.sal-s1.sal) > 0 Above results in all hikes of all employees
-
SubQuery Performace - IN clause or EXISTS clause
In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?
PrabhatKumar
- Oct 7th, 2010
The EXISTS function searches for the presence of a single row meeting the stated criteria as opposed to the IN statement which looks for all occurrences. Rule of thumb:If the majority of the filt...
Arpana
- Oct 10th, 2007
EXISTS is more efficient that IN , Because EXISTS use indexes of the table and hence scans the table faster, as well as it returns the boolean value (T or F), If T is received for EXISTS clause than t...
-
What is the output of the program?void main(){fork();printf(" Hello World");getch();}A. Hello WorldB. Hello World Hello WorldC. Error MessageD. None of these
B
LakshumaiahGoud
- Oct 3rd, 2010
it will print two times.if n fork calls then no.of processes will be 2^n
Bhoomika sharma
- Dec 16th, 2008
The answer is B as:the fork() calls the function i.e.it makes a copy of the parent process in the form of a child process. Thus,the two calls will be made to the function and as a result HEllo World is printed as twice and thus the answer.
-
Difference between a equijoin and a union?
srinu.oracle99
- Sep 1st, 2010
Equi Join is cartisan product of two tables and result is matching values of these tow tables but
both have common column.Union is just append two tables and restricts the duplicate rows and both tables have same number of columns.sunil_ronanki
- Nov 11th, 2008
Eqiui join is totally differene from unions Equijoin depends on a condition involving columns of both tables but where as in Union you can specify a condition based on a columns of the individual tables
-
What is the output of the program?#include<stdio.h>#include<conio.h>void main(){int i=1*4/3-27%3^2+100*0.5-(4>3?1:2);clrscr();printf("%d",i);getch();}A. 49B. compile errorC. 51D. 48
B
surender
- Jun 11th, 2007
49
-
What is the use of DESC in SQL?
Answer :DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.Explanation : The query SELECT * FROM EMP ORDER BY ENAME DESC will display the output sorted on ENAME in descending order.
anuraganu100
- Jul 9th, 2010
DESC is used with ORDER BY clause i.e.SELECT * FROM usermaster ORDER BY userid DESC
rekhask
- Sep 11th, 2007
DESC[RIBE] is a SQL*Plus command It is used to describe an Oracle Table, View, Synonym, package or Function.Note that because this is a SQL*Plus command you don't need to terminate it with a semicolon.Syntax: DESC table DESC view DESC synonym DESC function DESC package
-
The key word used in Oracle for string searching isA. SOUNDEXB. DECODEC. LIKED. HAVING
kranti
- Jul 28th, 2005
LIKE
-
Case function
if i have a Customer table with following datacust id custname1 A2 Band cars table with following datacar id cust id Model1 1 Toyota2 1 Honda3 2 Suzukiwhat is the query to give follwing out putcustid cust name model model 11 A Toyota Honda2 ...
pravintule
- May 28th, 2010
Select c.custid,c.custname,m1.model,m2.model as model1 from customer c1,car m1,car m2where c.custid=distinct(m1.custid) and c.custid(+)=m2.custid
vinayak1234
- Mar 30th, 2010
SELECT c.custid, c.custname, m.model FROM custtable AS c JOIN carstable AS m ON c.custid = m.custidgroup BY c.custid, c.custname, m.model
-
Inner Join Problem
Why IN query not worked in inner join?
sbsm_07
- Apr 29th, 2010
When we querying with in clause multiple records in resultset. inner join compare with one record only
krishna9231
- Jul 7th, 2008
Inner Join is nothing but self join. In self join the system wil take one record from tabel (i.e. first objective) and compare with the same table but objective is different.so at a time your comparin...
-
What are the privileges that can be granted on a table by a user to others?
Insert, update, delete, select, references, index, execute, alter, all
carlc40
- Apr 22nd, 2010
Oracle perspective -It depends on whether the user owns the table and if that user has the ADMIN privilege to grant privileges to others.?
rajanipriya
- May 8th, 2006
Alter, delete, index, insert, references, select, update. are the table(object)priviliges that can be granted by a user to others.
-
How do you know which index a table is using?
kirandba
- Apr 1st, 2010
Use below query to know index usage in SQL ServerSELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME], I.[NAME] AS [INDEX NAME], ...
-
How to hide the code in procedures,packages?
kirandba
- Apr 1st, 2010
CREATE PROCEDURE xyxWITH ENCRYPTION ASBEGIN...ENDBut you need to know database master key to decrypt this stored procedure to view code.
vavasudevan
- Feb 13th, 2007
Hi,Even we can use "Encryption" Keyword in MSSQL with Proc... this'll hide text of the Proc from User.Eg.,Create Proc Proc1As Select 1 While Taking sp_HelpText for Proc1, it'll return text written ins...
-
Loading Huge data files to Oracle
What is the process that we use to load the data faster when there are millions of files?
kirandba
- Apr 1st, 2010
Use SSIS. But with in SSIS use SQL Server Destination adaptor instead of OLEDB Destination. But when we use SQL Server Destination adapter we can only run either on server or from SQL agent job.
Ayush.sh
- Mar 31st, 2009
For loading data files or flat files into DB, Unix utility SQL Loader is best suited. can load milions of records in just few secs. Easy to use and compatible with Unix, shell, PERL. Uses control file(.ctl) and parameter file(.par)to direct instructions.
-
What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
psingla
- Mar 16th, 2010
SQL Sever:Truncate:Delete all the records from the table.Do not keep the deleted record in the log file.Reset the identity column to 1.Use fewer locks with table level locking.Tollback is not possible...
saravanan p
- Dec 5th, 2006
Hi,1. For truncate command, trigger will not get fired, but for Delete Command, Trigger will get fired.2. Truncate Is the DDL command whereas Delete is the DML command3.Once the truncate command ...
SQL Interview Questions
Ans