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

How to know the days or months or years between two employees in emp table.

jbabu

 Profile Answers by jbabu Questions by jbabu

• Dec 10th, 2007

Select hiredate,lead(hiredate,1) over(order by hiredate) next_months, round(months_between(lead(hiredate,1) over(order by hiredate),hiredate),3) months from emp;

Answer Question  Select Best Answer

How to fill Dataset from Datareader?

Venkat

 Profile Answers by Venkat Questions by Venkat

• Feb 12th, 2008

by using datasetds = new dataset()sqlDbAdapter ad = new sqlDbAdapter(sqlquery,connobject)ad.fill(ds,tablename)DataReaderdr = new sqlDataReader()sqlCommand sqlcmd = new sqlcommand(sqlqry,conObject)dr =...

Answer Question  Select Best Answer

What is SQL Tuning? How does it work? Thanks

abhi2433

 Profile Answers by abhi2433 Questions by abhi2433

• Feb 6th, 2008

SQL tuning is the process of ensuring that the SQL statements that an application will issue will run in the fastest possible time

Answer Question  Select Best Answer

What is the disadvantage of using "BETWEEN" for date feilds

saradajasti

 Profile Answers by saradajasti Questions by saradajasti

• Mar 24th, 2008

It won't work to selecting data in between months

Answer Question  Select Best Answer