B

sivaganeshb

• Aug 14th, 2007

Here, you are de-referring an un-intialized pointer(segmentation fault). A file called?"core" will create and it contains the "images of that program"

sabeena

• Apr 20th, 2007

I want to know what Core Dump means.

Answer Question  Select Best Answer

jpundalik

 Profile Answers by jpundalik Questions by jpundalik

• Dec 30th, 2009

Below are the few difference between Stored Procedure and TriggersBoth are stored objects and stored in data base dictionariesStored Procedure- Can pass parameters- Manual execution requiredTriggers:- No parameters can be passed - Automatical executed when the event occurs

chennoju

 Profile Answers by chennoju Questions by chennoju

• Aug 3rd, 2006

Stored procedure and Trigger both will be in the database in precompiled formate which ready execute, the main difference between these two isto execute the stored procedure programe need to type...

Answer Question  Select Best Answer

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...

Pallavi g rao

 Profile Answers by Pallavi g rao Questions by Pallavi g rao

• Apr 22nd, 2011

Update emp set gender=case when gender='f' Then 'm'else 'f'end

Elena

• Nov 8th, 2007

Update   set gender=(case gender when 'F' then 'M' when 'M' then 'F' end)

Answer Question  Select Best Answer

srinu.oracle99

 Profile Answers by srinu.oracle99 Questions by 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

 Profile Answers by sunil_ronanki Questions by 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

Answer Question  Select Best Answer

ratnam

• Aug 3rd, 2012

How write a SQL statement to query the result set and display row as columns and columns as row?

Vasanth Kumar

• Oct 6th, 2006

The simplest way to implement this in SQL 2000/OracleSelect * from table1Create a temp table with No of columns = No of rows in table 1No of rows = No of columns in table 1and insert the data into the temp table using a loop logic.

Answer Question  Select Best Answer

amy

• Mar 20th, 2007

Select e1.name, e2.name, e3.namefrom employee e1 left join employee e2 on e1.manager_id = e2.employee_idleft join employee e3 on e2.manager_id = e3.employee_id

biswa

• Jul 11th, 2006

 SELECT worker.ENAME || ' works for '  2  || manager.ENAME  3  FROM emp worker, emp manager  4  WHERE worker.mgr = manager.empno ;where emp is the tableEMPNO ENAME&n...

Answer Question  Select Best Answer

jimmy514in

 Profile Answers by jimmy514in Questions by jimmy514in

• Jul 2nd, 2010

Why cannot we use select * from table_name where rownum=70??

krishna

• Sep 26th, 2006

select * from emp where rownum<71minusselect * from emp where rownum<70;

Answer Question  Select Best Answer

How do you subtract two columns in oracle database, two columns are in data format.Example : inserttime column senttime column?

pravesh28

 Profile Answers by pravesh28 Questions by 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

 Profile Answers by rkh_301 Questions by 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';

Answer Question  Select Best Answer

How could i delete the distinct name from the table. the rest record would be available as it is in the table?

pravesh28

 Profile Answers by pravesh28 Questions by 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 ;

Answer Question  Select Best Answer

Lakshaman

• Jan 24th, 2007

An exampleWe accept user and password and validate likeselect 1 from users where username = 'username' and password = 'pwd';What if username string is passed like [x' or 1=1; --]select 1 from users where username = 'x' or 1=1; --' and password = 'pwd';

sabithagopi

 Profile Answers by sabithagopi Questions by sabithagopi

• Jan 23rd, 2007

SQL Injection happens when a developer accepts user input that is directly placed into a SQL Statementand doesn't properly filter out dangerous characters. This can allow an attacker to not only stealdata from your database, but also modify and delete it.

Answer Question  Select Best Answer

malapati

 Profile Answers by malapati Questions by malapati

• Oct 10th, 2008

By default the "select" statement retreives the data in "unsort" form. If we want to sort the data we need to use "ORDER BY" clause. eg: select * from < table name > order by < column name >;?if we specify "desc" after column name it sort out in desending order otherwise default is asending order

Lavu

• May 6th, 2007

If you are selecting the data from the table it will not sort the data. If you are using group by clause then it will sort the result in the ascending order other wise not.

Answer Question  Select Best Answer

Ayush.sh

 Profile Answers by Ayush.sh Questions by Ayush.sh

• Mar 31st, 2009

To add in above mentioned constraints for using functions in DML statements:- Called function should not end a transaction

raji_4u

 Profile Answers by raji_4u Questions by raji_4u

• Sep 19th, 2008

Who says we cannot?We can call stored functions from DML statements but follow some rules
The rules:----------1. Function should use only IN parameter mode. Don't use OUT or IN OUT mode.2. Functions used in Select statements should not update database tables, where as others can update database.

Answer Question  Select Best Answer

What is the process that we use to load the data faster when there are millions of files?

kirandba

 Profile Answers by kirandba Questions by 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

 Profile Answers by Ayush.sh Questions by 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.

Answer Question  Select Best Answer

sunil_ronanki

 Profile Answers by sunil_ronanki Questions by sunil_ronanki

• Oct 16th, 2008

Alter table drop constraint check [name of the constraint]

malapati

 Profile Answers by malapati Questions by malapati

• Oct 8th, 2008

Alter  table  drop  constraint  check;

Answer Question  Select Best Answer

seemu123

 Profile Answers by seemu123 Questions by seemu123

• Jul 1st, 2008

You can use like thisSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..Tablenameex:Select top 10...

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

One which i faced but till yet couldnt solved was like i am having 50 db's, each db's having 100 customersi wanted top 10 customer for each 50 db's according to their salary in oraclethough it sounds easy but  according to my knowledge its not so

Answer Question  Select Best Answer

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 query

Ashok Aaruu

 Profile Answers by Ashok Aaruu Questions by Ashok Aaruu

• Oct 22nd, 2011

Its not clear...... it will be execute correctly?

Siraj

• Oct 15th, 2011

Delete from table_name where rowid not in (SELECT max(rowid) FROM table_name group by (column_name))

Answer Question  Select Best Answer

If i have two table T1 having data of column C1,C2,C3 and C4 and T2 having data of column C5,C6,C7 and C8,How to copy Data of T2 to T1 or T1 to T2

Aakash

• Mar 22nd, 2015

INSERT INTO T1
(
SELECT
C5,
C6,
C7,
C8
FROM T2)

smamish

 Profile Answers by smamish Questions by smamish

• Mar 22nd, 2015

Code
 

Answer Question  Select Best Answer

Vipin

• Jul 7th, 2015

It is always a good practice to create a Clustered Index on the Primary key and make sure that the Primary key is sequential. A table can have only one clustered index where as a table can have unlimi...

saira banu

• Jun 10th, 2015

Table

Answer Question  Select Best Answer

How to delete reverse duplicate in oracle.
e.g i/p
col1 col2
hyd blr
mum del
del blr
blr hyd
blr del

i want in o/p
col1 col2
hyd blr
mum del
del blr

Priyanka Jaiiswal

• Aug 17th, 2017

SELECT a.col1 ,a.col2 from t1 a
where a.col1 < = a.col2

manish

• Feb 7th, 2017

SELECT a.mem_name,a.loc_name
FROM TAB4 a
WHERE a.loc_name = a.mem_name;

Answer Question  Select Best Answer

EID ENAME SAL SALMONTH
101 xyz 100 Jan 2015
101 xyz 200 Feb 2015
102 Abc 300 Feb 2015

I want output like this
Eid Ename hike
101 xyz 100
102 Abc 0

Akash

• Aug 15th, 2017

Can you elaborate what you are solving its not about duplicates

dan

• Jul 31st, 2015

The question is poorly stated, perhaps partially stated as well. But it is good that basic sample data is given. Does the table have data only for Jan 2015 and Feb 2015.? What if the salary changes we...

Answer Question  Select Best Answer