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

Genie Cool

• Jun 6th, 2007

If you are trying SQL Server 2000, try the code that gives the size in bytes...DECLARE @CalSize TABLE( TabID INT, ColSize INT)INSERT INTO @CalSize SELECT A.id, SUM(A.Length) A...

Priya

• Nov 27th, 2005

Select segment_name from dba_segments where bytes/1024/1024<100;

Answer Question  Select Best Answer

INOUTINOUT

roopali

• Jun 1st, 2007

IN : lets you  pass values to the  subprogram being calledOUT: lets you return  values to the caller of subprogramINOUT: lets you to pass values to the subprogram and return values to the caller of the subprogram.

SIVANARAYANA CHEKURI

• May 25th, 2007

INOUTIN OUTNO COPY

Answer Question  Select Best Answer

jaya

• May 29th, 2007

Hi,It seems your application is using a cursor with for update clause , where the other transaction (DML) will wait until the current one gets end.check the code , if this is not the case then there m...

Answer Question  Select Best Answer

SIVA

• May 25th, 2007

We can't?select?next value and current value?from views.

Answer Question  Select Best Answer