Display list of jobs, number of employees of each job from departments 10 and 20. List only records if number of employees in each jobs are more than 1.

DURGAPRASAD

• Jul 23rd, 2012

SELECT JOB,COUNT(EMPNO) AS NOOFEMP FROM SCOTT.EMP WHERE DEPTNO IN (10,20)
GROUP BY JOB HAVING COUNT(EMPNO) > 1

Answer Question  Select Best Answer

How do I reverse a dtring in Oracle without using PL/SQl and without using the reverse function??

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Apr 13th, 2012

Are you looking for something like this?"plsql function revstring(instring varchar2) return varchar2 is rstring varchar2(750) := ; iCnt pls_integer; begin for icnt in reve...

Answer Question  Select Best Answer

1) How to create login page in oracle 10g forms.

2) How to create an exe file of oracle 10g database

Sarat Teja

• Jan 5th, 2013

The login credentials will be requested at the time when you run a form on runtime of developer suit, that particular fmb/fmx is usually known as the login form or the master form from which a menu mo...

Answer Question  Select Best Answer

In which scenario we can use primary and unique key in same table???????

abinay

• Oct 6th, 2012

the combination of unique key and not null key is called primary key. In a table we use only one primary key.It is unique,it cant allow the null values. UNIQUE key ,in a table we use more than one un...

Answer Question  Select Best Answer

Explain the difference between object view and relational view.

Diptiman

• Dec 21st, 2015

A "Relational View" is the projection of the data using simple relational tables like: CREATE OR REPLACE VIEW relational_view (employee_name, department_name) AS SELECT employee_name, department_na...

Answer Question  Select Best Answer

jvilango

 Profile Answers by jvilango Questions by jvilango

• Nov 9th, 2006

The purpose of Product_user_profile table of SYSTEM is to control users from executing SQL commands.  For example, if you dont want one of your users to execute DELETE fommand, this can be implemented in this table.

bhanushiva

 Profile Answers by bhanushiva Questions by bhanushiva

• Jan 20th, 2006

The PRODUCT_USER_PROFILE (PUP) table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles.To create the PUP tableLog in...

Answer Question  Select Best Answer

Balaji

• Aug 5th, 2015

The way for accessing a remote object.

maqk

• Jan 2nd, 2006

What's the Difference between COM and DCOM?Obviously, the difference is that DCOM is distributed but COM is not. To be more precise, there are three main elements added to COM: The way for creating a ...

Answer Question  Select Best Answer

jagadishVarodia

• Apr 12th, 2006

For time being type below command at sql promptSQL>define_editor=viYou can add export EDITOR=vi in .profile and logou/login for permament changeHope this will solve it

Guna Sagar Challa

• Mar 27th, 2006

Hi,To set the editor for editing sql commands and PL/SQL code at the SQL*Plus (Unix: $sqlplus) enter the following command at ur sql prompt after logging indefine _editor = <path and file name of the exe for the new editor>Hope this solves ur probCheers,Guna Sagar Challa

Answer Question  Select Best Answer

dev

• Oct 11th, 2006

Hi,for every table it is giving the same answer like:SQL> select bytes from user_segments where segment_name='DEPT';     BYTES----------     65536why? I did compress on one table. eventhough it's giving same answer.Thanks in advance.

S.Madhu

• Mar 29th, 2006

 I have created a table in oracle 9i database. How can i know the storage prticulars of  a table  created in oracle database ?please give me the answer to my e-mail id.thank u

Answer Question  Select Best Answer

sulakshana

• Jan 16th, 2007

Try out with adopendynamic,adlockoptimistic.Also try it by  givingselect distinct(column_name) from table_namedo replyThanks and regards

Chandra

• Mar 18th, 2006

In this case record set is open  in adOpenForward and adLockreadonlyor (by removing the loaktype or open mode)rs.Open CadSql, Cnn

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

what harsha said is right.in addition to the above reports there are 3 more triggers1. VALIDATION TRIGGERS2.FORMAT TRIGGERS3.ACTION TRIGGERS

Harsha

• Jul 14th, 2006

Report Customization means taking the orginal oracle report and modifing ( changing layout, query- by adding some more field....) according the user requirement.There are 5 types of report triggers1)B...

Answer Question  Select Best Answer

Guest

• Apr 12th, 2007

Hi,If you are using SQL server then you have an in-built option in the SQL Server itself. You can read xml in db through stored procedures.sp_xml_preparedocument - search for this option in sql server.

Elango

• Jun 23rd, 2006

Hi,There are couple of ways to do it other than loader.1) You can load the file into a clob and make use of the sys.xmlparser and sys.xslprocessor packages to load it to files.2) You can load the file...

Answer Question  Select Best Answer

raja

• Oct 10th, 2006

    SQL: 1.it is a language for communicating with the oracle server to access data 2.it is based on ANSI standered sql.3.can"t be abbreviated.4.uses fns to perform some formatting.5.do...

madhu sudhan rao

• Sep 18th, 2006

sql*plus is a tool ( interface ) where we enter sql commands, its just like an command line interface like doswereas sql is query language with which we communicate with the database.in order to communicate with the database we can do only with the query language

Answer Question  Select Best Answer

Neeraj

• Nov 7th, 2006

You can write the query in the following way.select max(sal)-min(sal) difference from emp;

Manikandan

• Sep 22nd, 2006

Select max(sal)-min(sal) as Difference from employee;

Answer Question  Select Best Answer

sisindia

• Jun 7th, 2007

hi to all sql loversthe answer is-unable to create initial extent for segment in such table spacefailed to find sufficient contiguous space to allocate initial extent for segment being createduse ALTE...

madhu sudhan rao

• Sep 18th, 2006

Create table privilege is not grantedin order to grant create table privilege, connect to sys/manager and then type grant create table to

Answer Question  Select Best Answer

Amol Bawane

• Nov 15th, 2007

Yes we can use procedure in trigger...but not trigger in Procedure.ThanksAmol Bawane

Shailu

• Oct 6th, 2006

We can not use  trigger in procedure, but can call procedure in trigger. When u r  trigger code is  too lengthy then write procedure and call in trigger.e.gcreate  trigger <trig...

Answer Question  Select Best Answer

How do you send the output of your SQL* Plus session to a text operating system file

prateek2612

 Profile Answers by prateek2612 Questions by prateek2612

• May 15th, 2011

See spool command

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

well you want to see the output ina  text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spoo...

Answer Question  Select Best Answer

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 16th, 2007

Hi shravanam,Wht is this u r wrong?Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....)

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

Join is a query which retrieves related columns or rows from multiple tables. Self Join - Joining the table with itself. Equi Join - Joining two tables by equating two common columns. Non-Equi Join - ...

Answer Question  Select Best Answer

saginandkishore

 Profile Answers by saginandkishore Questions by saginandkishore

• Jun 20th, 2008

To execute sqlplus via Unix shell scripts the following parameters need to be initialized.(1.) ORACLE_HOME export ORACLE_HOME=Path to <ORACLE_HOME>(2.) ORACLE_SIDexport ORACLE_SID=Actual ORACLE_...

srinsr

• Mar 14th, 2007

$ORACLE_SQLPLUS -s $TCS_ORACLE_ID > $ORALOG 2>&1 <<EOFset serveroutput onset heading offset feedback offset verify offset linesize 250set pagesize 0set termout offexec solpk_upd_tcash ( '$SRC_SYS_CD', '$Date');commit;quit;EOF

Answer Question  Select Best Answer

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

oracle supports two types of joins: 1.oracle joins   cartesian join   equi join   non equi join   self join   outer  join is exhibited ...

pawan ahuja

 Profile Answers by pawan ahuja Questions by pawan ahuja

• Mar 8th, 2006

Hi all,Actually we r talking abt the ANSI join syntax,That's available in oracle 9i.this join cannotbe run in lower version means oracle 8i(8.17),oracle 9i releases1.The join syntax is left outer join,rigth outer join,full outer join.natural join,RegardsPawan Ahuja91(9342927335)  

Answer Question  Select Best Answer