rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 16th, 2007

Hi shravanam,Wht is this u r wrong?Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....)

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

Join is a query which retrieves related columns or rows from multiple tables. Self Join - Joining the table with itself. Equi Join - Joining two tables by equating two common columns. Non-Equi Join - ...

Answer Question  Select Best Answer

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 16th, 2007

Try it through MERGE

ROHIT_4444

 Profile Answers by ROHIT_4444 Questions by ROHIT_4444

• Mar 27th, 2007

SUPOOSE WE HAVE TWO TABLE R_ITEM_MASTER & ITEM_MASTERIN R_ITEM MASTER THERE ARE ITM_ITEM_CODE,ITM_DESC,ITM_UM,ITM_CURR_COST_RATE FOUR FIELDS BUT WE WANT TO INSERT RECORDS ONLY IN TWO COLUMSINSERT INTO R_ITEM_MASTER (ITM_ITM_CODE,ITM_UM) SELECT ITM_ITEM_CODE,ITM_UM FROM ITEM_MASTER

Answer Question  Select Best Answer

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures which are attached to a specific database object say a table. Stored procedures are not automatically run...

Amol Bawane

• Nov 15th, 2007

The basic difference between stored procedure and trigger is stored procedure can call explicitly, but trigger cannot call explicitly.Genarally trigger are used for Audit and trail. What should be the...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

* procedures will be called by user or by programs* Trigger will be executed or triggered only when it is fired....

Answer Question  Select Best Answer

Amol Bawane

• Nov 15th, 2007

Yes we can use procedure in trigger...but not trigger in Procedure.ThanksAmol Bawane

Shailu

• Oct 6th, 2006

We can not use  trigger in procedure, but can call procedure in trigger. When u r  trigger code is  too lengthy then write procedure and call in trigger.e.gcreate  trigger <trig...

Answer Question  Select Best Answer

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

here is the example for DBMS_SQL:CREATE OR REPLACE PROCEDURE delete_all_rows(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)IScursor_name INTEGER;BEGINcursor_name := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE...

knarender

 Profile Answers by knarender Questions by knarender

• Jul 2nd, 2007

By using Execute Immediate command

Answer Question  Select Best Answer

rajakumar_na

• Nov 6th, 2007

If group of columns or column which uniquely identifies each and every record of a table is called candidate key. Candidate key other than primary key is called alternate key.

Answer Question  Select Best Answer

rajakumar_na

• Nov 6th, 2007

Using SQLERRM, and SQLCODE functions we can find the error message related to the SQL Error code.

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

i. YOU CAN NOT DELETE A PARENT TABLE WITHOUT DELETING CHILDREN TABLES. BUT VICE VERSA CAN TAKE PLACE.II. IF YOU HAVE ITEM CATEGORY THEN U CAN HAVE GROUP BY EXPRESSION ON ITEM_CATEGORY.III. DELETE FROM...

sunil saini

• Feb 27th, 2007

(1) use cascade option in query

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

NO YOU CANNOT WRITE A FUNCTION WITHOUT RETURNING A VALUE.IT SHOULD RETURN ATLEAST ONE VALUE.........WITH REGARDS,SHARAT

Pawan Ahuja

• Dec 9th, 2006

No, we can not write a function witout a functionRegardsPawan Ahuja

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

TRY THISSELECT ENAME||' ' ' '||'S' FROM EMP:

Jos? Baptista

• Nov 19th, 2006

HiYou just need to do this: ename||'''||'s'.If ename := 'Scott', the output is Scott's.RegardsJos? Baptista 

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'/

subasini

• Nov 17th, 2006

USER_SOURCE data dictionary view describes the text source of the stored objects owned by the current user wether it is procedure or function. Its columns (except for OWNER) are the same as those in All_source data dictionary view .ThanksSubasini 

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

SYNTAX:INSERT INTO VALUES('&COLUMN1'(STRINGS,DATES),&COLUMN2);EXAMPLE:INSERT INTO EMP VALUES('&ENAME',&EMPNO);

rajanen

 Profile Answers by rajanen Questions by rajanen

• Jul 19th, 2006

SYNTAXinsert into table_name &column1,..... values (.......);e.g:insert into emp (emp_name,emp_id) values('&emp_name','&empid');

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

what harsha said is right.in addition to the above reports there are 3 more triggers1. VALIDATION TRIGGERS2.FORMAT TRIGGERS3.ACTION TRIGGERS

Harsha

• Jul 14th, 2006

Report Customization means taking the orginal oracle report and modifing ( changing layout, query- by adding some more field....) according the user requirement.There are 5 types of report triggers1)B...

Answer Question  Select Best Answer

I want to create a database containing info about the student, i,e their resume with photo, how can i store these details directly to oracle database?

amahanit

 Profile Answers by amahanit Questions by amahanit

• Oct 8th, 2007

Use LOB data types

Answer Question  Select Best Answer

lokesh

• Oct 4th, 2007

Here we need to use system parametrs which are available in report module.DESTYPE OR DESTNAME we need to use to print the output in specified printer.

Answer Question  Select Best Answer

prasads_delight1

 Profile Answers by prasads_delight1 Questions by prasads_delight1

• Sep 28th, 2007

The varchar2(30) will take 30 bites. Because the size is specified as 30. if you entered a data of only 20 chars the remaining 10 will be transformed to the other field or row. By this the wastage of the disk space can be minimised.

pkjayan

 Profile Answers by pkjayan Questions by pkjayan

• Apr 29th, 2007

Varchar2 does not pad the unused bytes.it only uses the number of bytes inserted+1(end of charector) of course <30!

Answer Question  Select Best Answer

prasads_delight1

 Profile Answers by prasads_delight1 Questions by prasads_delight1

• Sep 28th, 2007

 The way the data maintained in the collection of tables can be explained by the data structure. The structure of database will show on which conditions the database will be maintained with out inconsistancy.

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Sep 27th, 2007

A sequence generates a list of unique numbers that identifiy the rows and columns of a table.

eswar

• Jul 31st, 2007

Sequence is nothing but a database object which creates an integer value automatically with out duplicates.

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 26th, 2007

You can use the proc *C in the pl/sql. and for the second question you have to configure it e.g isqlplus/ oem grid etc

Answer Question  Select Best Answer

naveen5555

 Profile Answers by naveen5555 Questions by naveen5555

• Sep 22nd, 2007

Installation of ORACLE 9i in LinuxRefer this page http://ivan.kartik.sk/oracle/install_ora9_elinux.html#st1

Answer Question  Select Best Answer