deviji2000

 Profile Answers by deviji2000 Questions by deviji2000

• Oct 15th, 2007

hi,   v use joins to get details from both the tables thz kind of joins r called  outer joins   to get the missed statements.select  e.eno, e.ename, e.deptnofrom emp e, d...

Nandakumar

• Jan 28th, 2007

Yes, you can get all the departments along with the employee details, plus the department for which no employee exists. Here you go using outerjoin, select a.employee_id, a.email, a.salary, a.departm...

Answer Question  Select Best Answer

raj1402

 Profile Answers by raj1402 Questions by raj1402

• Oct 12th, 2007

You can use oracle as Database and Jsp for scripting!!!

prasadmeduri

 Profile Answers by prasadmeduri Questions by prasadmeduri

• Feb 14th, 2006

Hi,You can use any type of webapplications for this task.I think ASp/JSP will be of great use and benefit.Keep database(SQLServer or Oracle) and your IIS/Weblogic on one dedicated machine for ser...

Answer Question  Select Best Answer

I dont knowplz give the ans. through my email

Priestly George Varghese

• Oct 10th, 2007

If you are creating trigger using before keyword, then the trigger will fire before the particular query.If you are creating trigger using?after keyword, then the trigger will fire?after the particular query.

REDDY

• Nov 18th, 2005

Your question is not clear, when creating triggers we give the trigger timing (i.e) BEFORE or AFTER and the trigger will file accordinglycreate or replace trigger <trigger name>  timing <...

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

If your answer is yes, explain the steps.

gkbiswal

 Profile Answers by gkbiswal Questions by gkbiswal

• Sep 29th, 2007

Yes we can.create or replace trigger trg_testbefore insert on empbeginnull;end;create synonym trg_syn for trg_test;

Answer Question  Select Best Answer

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 25th, 2007

select count(*) from all_users;

Kannan

• Jan 6th, 2007

Sybase:sp_who will help to find the available users.....select * from sysusers - it used to find the no.of users in ur DB

Answer Question  Select Best Answer

For example::In a table Table1, I want 2 make the column "Column1" as primary key and I want the first letter must start with 'S'

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 23rd, 2007

I guess it would work if u  add a check constraint as follows:constraint check (column1 like 's%');

Answer Question  Select Best Answer

Himanshu

• Sep 6th, 2007

You just need to put as in between column name and alias.Select sname as "s-name" from emp;

matloob Hussain

• Oct 28th, 2005

by just defining the alias "EMPLOYEE--ID" in your SQL for example select employee_id "EMPLOYEE--ID" from emp; 

Answer Question  Select Best Answer

A bad answer is count them (SELECT COUNT(*) FROM table_name)A good answer is :-'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g. USER_TABLES or ALL_TABLES).The best answer is to refer to the utility which Oracle released which makes it unnecessary to do ANALYZE TABLE for each Table individually.

safdar

 Profile Answers by safdar Questions by safdar

• Sep 4th, 2007

If you want to find the number of Rows in table SELECT COUNT(*) FROM EMP;This is valid query

gony

 Profile Answers by gony Questions by gony

• Feb 8th, 2006

Use SY-DBCNT. It is used to count number of rows in a databse table.in internal tables we use SY-TABIX.cheers dude....bye

Answer Question  Select Best Answer

For example In my table one datetime field example modified_date_time.its displaying 2006-08-18 23:28:23 (here its rounding seconds)But I want the format like 2006-08-18 23:28:22.123456 (I want the absolute value for seconds like yyyy-mm-dd HH24:mi:ss.milliseconds.

Siva

• Aug 23rd, 2007

You can use like the followingSELECT TO_CHAR(systimestamp,'yyyy-mm-dd HH24:mi:ss.FF') FROM DUAL;which gives you like 2007-08-23 14:12:36.769726

Answer Question  Select Best Answer

Oracle uses work area to execute SQL statements and store processing information PL/SQL construct called a cursor lets you name a work area and access its stored information A cursor is a mechanism used to fetch more than one row in a Pl/SQl block.

syam sundar

• Aug 17th, 2007

Oracle ueses the private area for excute SQL statements and store processing information. The private area is called as CONTEXT AREACURSOR: cursor is a handle or pointer to the context area.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

cursor is a private sql working area.cursor could be two type implicit or explicit cursoronly explicit cursor are assigned private sql working area.

Answer Question  Select Best Answer

Shanthi

• Aug 15th, 2007

Yes.. Using execute immediate which executes dynamic sql and pl/sql

Answer Question  Select Best Answer

jitendra

• Aug 8th, 2007

You can use execute_imediate in PL/SQL.

Rama Krishna,Yerra

• Aug 2nd, 2006

This is also another method.. Oracle Supports a built-in package DBMS_SQL by this we can execureWe must use the following methods. PARSE()BIND()Thanks&REgdsRamki,TCS,Hyd

Answer Question  Select Best Answer

sindhu

• Aug 2nd, 2007

Thanks for your answer.It helped me alot for my interview.

BinduJoseph

 Profile Answers by BinduJoseph Questions by BinduJoseph

• Jan 22nd, 2007

First lets consider these two tables. AKey Data----------- ----------1 a 2 b  BKey Data----------- ----------1 c 3 d ...

Answer Question  Select Best Answer

Lovely Gahlawat

• Jul 27th, 2007

Reverse -key index is index that reverse the data of the being indexed column. For example if the column value contains LOVELY, the reverse-key index will be YLEVOL.This index very much useful where u...

Answer Question  Select Best Answer

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 18th, 2007

Select stud_name, greatest(s1,s2,s3,s4,s5) from stud_table;

Answer Question  Select Best Answer

ismail mohd

• Jul 5th, 2007

A long time ago, the only optimizer in the Oracle database was the Rule-Based Optimizer (RBO). Basically, the RBO used a set of rules to determine how to execute a query. If an index was available on ...

Answer Question  Select Best Answer

amarnathtnl

 Profile Answers by amarnathtnl Questions by amarnathtnl

• Jun 29th, 2007

Hi,The answer for ur first Ques isselect * from emp where empno IN(select mgr,count(*) from emp group by mgr having count(*)>=1)TO SEE THE EXISTING CONSTRAINTS ON the TABLE  empselect * from user_constraints where table_name='EMP';note : table name must be given in capitals

Answer Question  Select Best Answer

Punitha

• Jun 29th, 2007

you can use sum functionselect sum(sal) from emp;

Answer Question  Select Best Answer

sudeep_srivastava

• Jun 19th, 2007

In Trigger there is a special Table Called INSERTD. it takes the value from transation log.In the After Insert Trigger....SELECT Id,Name FROM INSERTEDyou can catch these values in a variable.

Anu

• Feb 6th, 2006

You can get the newly entered row in oracle using this query.. I dont know using triggers.Let me know if someone gets it. select sno,sname from dup_rows where rowid = (select max(rowid) from dup_rows);

Answer Question  Select Best Answer