How to insert a record in two tables with single insert statement ?

Nazeera Jaffar

• Sep 30th, 2012

Answer:

Code
 

chandra411

 Profile Answers by chandra411 Questions by chandra411

• Sep 2nd, 2008

Using merge concept, we can insert a record at a time into two tables.

Answer Question  Select Best Answer

Niranjan Dubey

• Jan 6th, 2012

Dual is a Dummy table when we execute query.. "sql Select * from dual it will show .. DUMMY X It ha...

Rabindra_Kumar

 Profile Answers by Rabindra_Kumar Questions by Rabindra_Kumar

• Oct 28th, 2009

You can perform any DML operations in dual table provided that you have been given the privilege to do so.However never try to perform any DML operations (delete/insert/update) in dual table because d...

Answer Question  Select Best Answer

How to create table emp1 based on emp, except comm column?

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

CREATE TABLE emp1 AS (SELECT empno, ename, hiredate, s

nathsambu

 Profile Answers by nathsambu Questions by nathsambu

• Dec 19th, 2008

Create table emp1 as select * from emp;

Answer Question  Select Best Answer

How to count number of records in a table without using COUNT function?

Sandipan

• Sep 6th, 2012

Select sum(1) from emp;

Code
 

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 30th, 2012

Select max(rownum) from
(select ROW_NUMBER() over (order by col_name) as rowNum from table_name)
withRowNum

Answer Question  Select Best Answer

Write SQL Query to find the department (ID) wise counts in the company.
Schema "employee" contains "employee_id", "employee_name", "dept_id".

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

"sql WITH EMP2 AS( SELECT DEPTNO,COUNT(*) LASAL FROM EMP GROUP BY DEPTNO) SELECT E.EMPNO,E.ENAME,E.DEPTNO,E2.LASAL FROM EMP E ,(SELECT * FROM EMP2) E2 WHERE E.DEP...

M JAGADADEESH

• Mar 10th, 2016

Code
 

Answer Question  Select Best Answer

How to replace only third character of employees name with * from employee table?

Ankit

• Mar 7th, 2018

SELECT REPLACE(NAME,SUBSTR(NAME,3,1),*) FROM Friend_Birthday

PAVAN

• Jan 19th, 2018

SELECT REGEXP_REPLACE(FIRSTNAME, SUBSTR(FIRSTNAME,3,1), *,1,1) FROM EMPLOYEE;

Answer Question  Select Best Answer

SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output BCDEINSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2) output 7 (2nd occurence of '-')

Nicsmart

 Profile Answers by Nicsmart Questions by Nicsmart

• Mar 31st, 2010

SUBSTR------The substr functions allows you to extract a substring from a string.The syntax for the substr function is:substr( string, start_position, [ length ] )string is the source string.  st...

ashish88

 Profile Answers by ashish88 Questions by ashish88

• Jun 10th, 2008

hi Buddy,   Substr only give the sub part of the stringSubstr(String,'start postion','length')Substr('ABCDEFAG',3,7); /*out put is =cdefag */Instr to give only possio...

Answer Question  Select Best Answer

sanjay mehra

• Apr 3rd, 2020

Not possible

prerrak_pandya

• Mar 6th, 2020

Thank_you, its really worked!
its make my day,
something awesome new to learn

Answer Question  Select Best Answer

sanjay pradhan

• Sep 26th, 2014

Alter trigger trigger_name disable

vijaya

• May 11th, 2013

Alter trigger trigger_name disable/enable all triggers.

Answer Question  Select Best Answer

aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

Use DML Triggers to apply the same action to another table as well.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Write trigger

Answer Question  Select Best Answer

Ekta Raina

• Jul 14th, 2011

Transparent Network Substrate

mselva84

 Profile Answers by mselva84 Questions by mselva84

• Jun 28th, 2010

Oak Ridge Automatic Computer and Logical EngineRegards,Manikandan SelvarajandB Professionals India Pvt LimitedChennai (TN)India.

Answer Question  Select Best Answer

Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• May 3rd, 2010

OUTER JOIN is the way to collect records in case of lack of true join condition.

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 29th, 2008

outer join is that type of jon which retrives the matach & alson unmatached recores also from the tables

Answer Question  Select Best Answer

select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') <'col_name')group by level;Example:Given a table called emp with the following columns:-- id number-- name varchar2(20)-- sal number---- For the second lowest salary:-- select level, min(sal) from emp-- where level=2-- connect by prior sal < sal-- group by level

NITYANAND

• Oct 7th, 2007

TO find out nth LOWEST value, e.g. salary from emp table without using ROWNUM & DESC/ASCSELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal))     &...

Ishita

• Oct 4th, 2007

Easiest wayselect top 1 name from emp where name>(select min(name) from emp) order by nameIshita.

Answer Question  Select Best Answer

ashok panguluri

• Feb 11th, 2012

Primary key: The key which is unique and not allow the null values nothing but primary key. Each table contain only one primary key.

Candidate key: The key which is opt for the primary key is nothing but candidate key, the table can contain number of candidate key as per requirement.

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Primary key defines the uniqueness of a row. there should be no null value in primary key. The keys which are opt for primary key known as candidate keys. In a table candidate keys are the candidates...

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

Desc table_name

safdar

 Profile Answers by safdar Questions by safdar

• Feb 14th, 2008

HI I AM SAFDAR DOGAR create table dept1( deptno number(10) constraints pk_deptno primary key, dname varchar2(20), loc varchar2(20 ));desc user_constraints;select constraint_name,constraint_type from user_constraints where table_name='DEPT1';AM I RIGHT

Answer Question  Select Best Answer

Dhiraj

• Aug 29th, 2011

Select distinct * from table_name

shiiva

 Profile Answers by shiiva Questions by shiiva

• Feb 4th, 2011

Delete the Records selected from the below query:select a.* from emp1 a, emp1 bwhere a.empno = b.empnoand a.rowid < b.rowid  shiv

Answer Question  Select Best Answer

Ajay Kumar

• Mar 21st, 2007

9i it supports the Jdeveloper and Application server where 8i doesn't

rakhee

• Sep 11th, 2006

Ora8i doesnt follow all codd rules but ora9i follows all the 12 rules of codd

Answer Question  Select Best Answer

monika1985

 Profile Answers by monika1985 Questions by monika1985

• May 28th, 2008

Select sal from emp ewhere 4=(select count(distinct(sal) from emp where sal>e.sal)

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT * FROM  (SELECT  ename ,sal,                   dense_rank() over (ORDER BY sal DESC) max_sal        FROM emp)WHERE max_sal= 5;

Answer Question  Select Best Answer

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Dec 2nd, 2010

SQL> select last_name,salary,rn from (select b.*,rownum rn from (select last_name,salary   from employees)b) where mod(rn,2) = 0;LAST_NAME        &...

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 25th, 2007

select*from emp where (rowid,1) in(select rowid,mod(rownum,2)  from emp);

Answer Question  Select Best Answer

jomarie

• Sep 2nd, 2014

This is formed when join conditions is omitted or invalid

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

When a join condition is omited when getting  result from two tables then that kind of query gives us Cartesian product, in which all combination of rows displayed. All rows in the first table is joined to all rows of second table......

Answer Question  Select Best Answer