List all customer (user id, name, and e-mail), number of charging, total charging,number of transaction and total number of transaction value?If u have these tables:1- 'Credit_card'columns: credit_number,type,value,Customer_ID.2-'Coupon'columns: Coupon_number,value,password,Customer_ID3-'Customer'columns: Customer_ID,Fname,Mname,lname,E_mail,password,bdate,tot_trans,mobil_no,hom_no,ex_id_date,current_Balance.

friends_mukesh

 Profile Answers by friends_mukesh Questions by friends_mukesh

• Feb 19th, 2008

Hi, One of the solution is as follow: select cust.customer_id,fname,mname,lname,e_mail,credit.tot_credit+coupan.tot_coup no_of_recharge,credit.tot_credit_val+coupan.tot_coup_val tot_recharging,to...

Answer Question  Select Best Answer

CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Answer Question  Select Best Answer

shanthi_9881

 Profile Answers by shanthi_9881 Questions by shanthi_9881

• May 8th, 2008

In sqlserver 2005 we can use as follows to retreive the date part of the given date or sys dateselect datepart(dd,getdate())

Dharmendra Gohil

• Sep 26th, 2006

  Date Functions:  =============Oracle stores dates in an internal numeric format:century,year,month,day,hours,minutes and secondsDefault display format is DD-MON-YYYYOracle stores...

Answer Question  Select Best Answer

sravee123

 Profile Answers by sravee123 Questions by sravee123

• Jun 17th, 2008

Select ROWNUM, col1, col2 from tablename;

Dr. Codd

 Profile Answers by Dr. Codd Questions by Dr. Codd

• Jun 16th, 2008

SELECT ROWNUM,table_name.* FROM table_name;

Answer Question  Select Best Answer

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

VARCHAR2: Max Size=4000 bytesCHAR: Max Size=2000 bytesNUMBER(p,s): The precision p can range from 1 to 38.               &nbs...

Rama Krishna,Yerra

• Aug 2nd, 2006

The Max Size is upto 32.Thanks&RegdsRamki,TCS,Hyd

Answer Question  Select Best Answer

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

It is a subquery which is evaluated once for each row processed by parent statement.

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,The Oracle Server performs a correlated subquery when the subquery references a column from a table reffered to in the parent statement. A correlated subquery is evaluated once for each row pr...

Answer Question  Select Best Answer

TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 27th, 2008

Truncate is faster than delete as it does not generate rollback segment.

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 27th, 2008

TRUNCATE -  Truncate is a ddl command.DELETE-     Delete is a dml command.TRUNCATE - We can not use 'where' clause with truncate.DELETE-      We can use 'where '  clause  with delete .

Answer Question  Select Best Answer

sweetytrivedi

 Profile Answers by sweetytrivedi Questions by sweetytrivedi

• Jun 24th, 2008

If a view is based upon a single table then DML operations can be performed on it, while if a view is based upon more than two tables then it is a complex view and DML operations can be performed using instead of triggers.

Srikanth

• Nov 7th, 2006

A view can be manpulated by using instead of triggers

Answer Question  Select Best Answer

In which section of a PL/SQL block is a user defined exception waste?

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by vishakha_jain81

• Aug 7th, 2008

In exception block

Answer Question  Select Best Answer

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by vishakha_jain81

• Aug 12th, 2008

For DDL commands, We cannot do autocommit off. It is modify structure?of database object such as table, view and these commands have automatically commit.Set autocommit on/off is used for DML.

lovely sethii

 Profile Answers by lovely sethii Questions by lovely sethii

• Jun 17th, 2008

By using set autocommit on we can do it

Answer Question  Select Best Answer

Gayathri Panchangam

 Profile Answers by Gayathri Panchangam Questions by Gayathri Panchangam

• Sep 4th, 2008

Yes.Becoz sysdate contains date and time.For example: if u create a table like thiscreate table ex(id number,date1 date defualt sysdate unique);u get table created. After that if u insert rows in that...

lovely sethii

 Profile Answers by lovely sethii Questions by lovely sethii

• Jun 17th, 2008

Yes it will

Answer Question  Select Best Answer

niteshaggarwal

 Profile Answers by niteshaggarwal Questions by niteshaggarwal

• Oct 20th, 2008

The ROWID of that row and the Data value on which that index is created will be inserted in index file. ROWID have row address, which will locate the row at the physical level and thus accessing of that value will be fast.

Answer Question  Select Best Answer

Haraprasad

 Profile Answers by Haraprasad Questions by Haraprasad

• Nov 3rd, 2008

SQL%ISOPEN exists. Oracle always evaluates this to FALSE as PL/SQL closes implicit cursors immediately after they are executed.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

sql%isopen is there but it will always return "false" for implicit cursor

Answer Question  Select Best Answer

sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 23rd, 2009

These are the querys:- FOR Odd number of records: select * from emp where (rowid ,1) in (select rowid, mod(rownum,2) from emp);   FOR Even number of records: select * from emp where (rowid ,0) in (select rowid, mod(rownum, 2) from emp); try.........................

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 30th, 2008

We can use the below query to get the odd record of the table  --select r from (SELECT rownum r FROM EMP)where mod(r,2) != 0We can use the below query to get the even record of the table  --select r from (SELECT rownum r FROM EMP)where mod(r,2) = 0

Answer Question  Select Best Answer

sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 23rd, 2009

For - values it return (-1);for 0 it return (0);for + values it return (+1);

qwe

• Mar 29th, 2007

SIGN (a): Returns 1 if a is positive ,-1 if a is less than 0 and 0 if a is 0

Answer Question  Select Best Answer

sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 23rd, 2009

use the following syntex for drop the columnalter table emp drop column ename;

NARENDRA

• Dec 12th, 2006

Alter table?TABLENAME drop column?COLUMNNAME Generally rollback cant be followed are implemented along with these DDL statements. The commit statement automatically involves.

Answer Question  Select Best Answer

sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 23rd, 2009

select deptno,sum(sal) from emp                             ...

thumatinagaraju

• Oct 23rd, 2006

Hiin where condition we cann't use group function but having clause allows it, both r used 4 data restriction only.group by is used 4 grouping similar items.

Answer Question  Select Best Answer

Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.Data Manipulation Language: INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT.Transactional Control: COMMIT & ROLLBACKSession Control: ALTERSESSION & SET ROLESystem Control : ALTER SYSTEM.

gdurga

 Profile Answers by gdurga Questions by gdurga

• Jun 15th, 2009

DDL: Data Defintion LanguageDML: Data Manipulation LanguageTCL: Transaction Control LanguageDCL: Data Control Language

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

DDLDMLDCLTCLSELCT

Answer Question  Select Best Answer

gdurga

 Profile Answers by gdurga Questions by gdurga

• Jun 18th, 2009

1. DDL: Data Definition Language2. DML: Data Manipulation Language3. TCL: Transaction Control Language4. DCL: Data Control Language5. DQL: Data Query Language

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

                                 &n...

Answer Question  Select Best Answer

Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following:  select * from v$version;

emraan

 Profile Answers by emraan Questions by emraan

• Dec 29th, 2009

      select * from v$version

deepakonroll

 Profile Answers by deepakonroll Questions by deepakonroll

• Dec 26th, 2007

Just type define on your sql prompt ..you will get required info..

Answer Question  Select Best Answer