Punitha

• Jun 29th, 2007

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

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

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

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

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

The Oracle9i database offers join syntax that is SQL: 1999 Compliant. Prior to release 9i, the join syntax was different from the ANSI standards. The new SQL: 1999 Compliant join syntax does not offer any performance benefits over the Oracle proprietary join syntax that existed in prior releases.

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

AiM

• Aug 23rd, 2014

Trigger code to create a trigger in disable mode starting 11g "oracle create or replace trigger prac_trig_emp1 before insert or update OR DELETE ON emp1 REFERENCING NEW AS NEW OLD...

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

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Dont user select */in/write minimal cond

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

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

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

 SELECT BYTES/1024     FROM DBA_EXTENTS  WHERE OWNER = 'SCOTT'       AND SEGMENT_NAME = 'EMP';  This will return you size of table in Kilo Bytes.  User is Scott and Table is Emp.

Answer Question  Select Best Answer

vaibhav Tyagi

 Profile Answers by vaibhav Tyagi Questions by vaibhav Tyagi

• Oct 21st, 2007

ROWLOCK Use row-level locks when reading or modifying data. PAGLOCK Use page-level locks when reading or modifying data. TABLOCK Use a table lock when reading or modifying data. DBLOCK Use a database...

Answer Question  Select Best Answer

ritesh_ksingh

 Profile Answers by ritesh_ksingh Questions by ritesh_ksingh

• Apr 21st, 2008

To process an SQL statement, a DBMS performs the following five steps: The DBMS first parses the SQL statement. It breaks the statement up into individual words, called tokens, makes sure that the sta...

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

ALTER TABLE table_nameADD CONSTRAINT table_column_pk PRIMARY KEY (column_name);It is a table level primary key constraint applied on an existing table. SELECT TO_CHAR(DOB, 'DD-MM-YYYY')   FROM table_name;

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

CREATE TABLE table_name(col1 VARCHAR2(20));INSERT INTO table_nameVALUES(TO_CHAR(SYSDATE, 'HH:MI:SS'))While creating table you must keep in mind the datatype must be Varchar2 for required column

Answer Question  Select Best Answer

vanigreat

 Profile Answers by vanigreat Questions by vanigreat

• Jan 17th, 2008

select (to_date('31/01/2008','dd/mm/rrrr')-to_date('01/01/2008','dd/mm/rrrr')+1) - (select count(days) from (selectto_char(to_date('01/01/2008','dd/mm/rrrr&...

Answer Question  Select Best Answer

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

Dear Shruti,First query the data dictionary view "USER_CONS_COLUMNS" to find the constraint name.Then instead of dropping the constraint just disable it.step1:--> select constraint_name,c...

Answer Question  Select Best Answer

I cant drop the whole column because that is interlinked with my process? I have declared not null on a column, I have to change it

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

Dear Sarika,Instead dropping the constraint just disable the constarint.The command is:Alter table table_name disable constraint constraint_name;try it and reply me

Answer Question  Select Best Answer

How to see on what coloumns the indexes have been created?

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 29th, 2007

SELECT * FROM ALL_INDEXES WHERE TABLE_NAME = 'table_name'-- It will give u all indexes in required table

Answer Question  Select Best Answer