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

No.

Shantanu

• Aug 17th, 2012

You cant directly use commit in triggers. You have to use PRAGMA Autonomous_Transaction or you can call other procedure or function, but other procedure or function should also have PRAGMA Autonomous_Transaction in it.

Jagan

• Aug 21st, 2011

Yes, by using autonomous transaction

Answer Question  Select Best Answer

bhagyashree010

 Profile Answers by bhagyashree010 Questions by bhagyashree010

• Jul 20th, 2010

SELECT COUNT(e.ename), d.dname FROM emp e, dept d WHERE d.deptno=e.deptnoGROUP BY d.dname HAVING COUNT(e.ename) > 20It is the same...only diff is...use "dname" in group by clause , not "deptno"Thanks

isha123

 Profile Answers by isha123 Questions by isha123

• Aug 9th, 2006

Select e.empno "Subordinate",e.ename "Emp Name",e.mgrID "ManagerID",m.ename "Manager Name",m.empno "Employee Number" from emp e JOIN emp m where (e.mgrid=m.empno);

Answer Question  Select Best Answer

vidya

• Oct 30th, 2007

Where clause doesnt allow group functions.You need to use Having Clause.i.e Having count(*)>1

ROHIT_4444

 Profile Answers by ROHIT_4444 Questions by ROHIT_4444

• Mar 28th, 2007

IN THIS PREV NO EXPRESSION I PUT = IT WORK BUT ONLY SIMILAR EXACT QUERY IS DELETE FROM  WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM  GROUP BY <DUPLICATE VALUE FIELD NAME);IT'S WORK SURE

Answer Question  Select Best Answer

aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

No data found is an exception where as %not found is a cursor attribute.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

No data found is exception where as %notfound is retrn by exception

Answer Question  Select Best Answer

If you have a three columns table with one index on 2nd Column. In the SELECT statement you retrived column 1, can index be used or not?

amitsrivastava115

 Profile Answers by amitsrivastava115 Questions by amitsrivastava115

• Aug 2nd, 2011

Use index in the where clause , this way you can use it other wise not ...

geetha

• Jul 30th, 2011

Index will be used if the retrieval is based on an indexed column .if the where clause uses a column with index then the query will be executed based on that index.

Answer Question  Select Best Answer

The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are passed to a procedure and receive results. Formal parameters are the placeholders for the values of actual parameters

srinivas

• Feb 6th, 2016

How can I differentiate local veritable and formal parameter? In class I have variable called a, in that class one method has formal parameter is "a" and another local variable also "a".

Ravindra Kumar

• Dec 7th, 2015

The actual parameter is when you actually pass real value in calling that function. And, the formal parameter is the parameter as defined on the function signature.

Answer Question  Select Best Answer

venki

• Jul 23rd, 2011

Try this its working insert into tablename (vname)values(chr(39)||'name'||chr(39))

output:- 'name'

Ajit

• Jul 13th, 2011

Here all have given the answer which is for hard coded value for some predefined word. He is asking and I am too looking for the this Question "ANY DATA".If user don't know whether the coming strin...

Answer Question  Select Best Answer

minak

 Profile Answers by minak Questions by minak

• Apr 22nd, 2008

declare @a varchar(1000),@tblname varchar(100),@b nvarchar(1000)declare @startcol int,@i int, @endcol intselect @startcol = 11, @endcol =13, @a='', @tblname = '<tablename...

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 18th, 2007

Select * from(select rownum r ,a.* from employees a)where r between 11 and 40

Answer Question  Select Best Answer

saishradha

 Profile Answers by saishradha Questions by saishradha

• Aug 13th, 2010

Below is the correct query according to me..
select to_date('19-aug-2010', 'dd-mon-yyyy') - to_date('10-aug-2010', 'dd-mon-yyyy') as numberofdays from dual;
Let me know if it does not work..

Sairam..
 

vikas_lomate

 Profile Answers by vikas_lomate Questions by vikas_lomate

• Aug 13th, 2010

Use below query to find number of days between two given dates -SQL> select to_date('30-aug-2010','dd-mon-rrrr') - to_date('20-aug-2010','dd-mon-rrrr') num_days from dual;NUM_DAYS
----------
10
SQL>

Answer Question  Select Best Answer

display the 5th lowest sal from emp table using Correlated subquery

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select * from Hello h where 5=(select count (distinct amt) from hello where h.amt>amt)

This will give the 5th record from lowest

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Mar 1st, 2012

Select rank,salary from (select rownum as rank, salary from (select distinct(salary) from emp order by salary)) where rank=5;

Answer Question  Select Best Answer

Does View occupy memory? If we delete the base table of existing view, What happens?

Read Best Answer

Editorial / Best Answer

Mad Hatter  

 Profile Answers by Mad Hatter Questions by Mad Hatter

• Member Since Nov-2008 | Nov 4th, 2008

---

View does not occupy memory, but Oracle keeps view code in its dictionary (you can check in user_views, for example)
If you delete the base table, the view becomes INVALID.
In order to make it valid again, you have to ether build the deleted table again, or create anotehr view with the same name and structure as deleted table, or create synonym with the same name as deleted table, which will point to the table with the same structure.

pkshve

 Profile Answers by pkshve Questions by pkshve

• Sep 12th, 2010

Views are database objects - they are just SQL code stored in database which will be executed every single time the view is called. Database will check the existance of columns and tables in the base ...

manimehra905

 Profile Answers by manimehra905 Questions by manimehra905

• May 18th, 2010

View does not occupy memory as it only provides a way for watching multiple views of an object: Table. Moreover, it is a virtual table which does not take space.It provides DATA HIDING.For e.g. i...

Improve Answer

I have table with col1 values , col2 1st row value should be same col1 1st row, then col 2 row onwards row each should added each row values eg: col1 values 10,20,30. Etc, in col2 values display like 10, 30,60 etc. how we can write sql query ?

roshan.gwr

 Profile Answers by roshan.gwr Questions by roshan.gwr

• Mar 13th, 2015

Using Lag we can get it.
Select col1,col1+lag(col1,1,0) over (order by col1) col2 from table;

Vinod Kumar G M

• Nov 7th, 2014

SELECT COL_NAME , SUM(COL_NAME) OVER ( ORDER BY COL_NAME) FROM TABLE_NAME

Answer Question  Select Best Answer

Query to select distinct values without using distinct

Ashok

• Mar 21st, 2016

There are four ways for this.
1. Using distinct keyword
2. Using group by on all columns
3. Using Union operator
4. Using Analytical functions

Akshay Kadam

• Mar 27th, 2015

SELECT DISTINCT LASTNAME FIRSTNAME
FROM EMP;

Answer Question  Select Best Answer

TABLESVIEWSINDEXESSYNONYMSSEQUENCESTABLESPACES etc

suresh

• Mar 13th, 2015

Table,view,procedure,function,package,synonums,triggers,index,sequencess

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

There are 5 objects:-1.Table2.View3.Synonyms4.Sequences5.Index

Answer Question  Select Best Answer