jmriaz

 Profile Answers by jmriaz Questions by jmriaz

• Aug 14th, 2007

A Pl/SQl is Procedural language extension for SQl.U can do certain thingslike creating blocks,procedures,functions,triggers etc..A cursor is a private work area(or u can say it a place)...

rakesh.apps

 Profile Answers by rakesh.apps Questions by rakesh.apps

• Aug 8th, 2007

PL/SQL is a procedural language which is used to make set of operations on the database.Actually the code is written in the form of PL/SQL blockAnd Cursor is a mechanism which is used to retrieve the data(rows) from the table.

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Aug 14th, 2007

In layman terms,SQL is a language to query a database.SQL plus is an editor (provided with oracle) to write/execute sql commands.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Jul 10th, 2007

Sql is the command line prompt, where we can enter commands of DDL,DML and DCL to perform transaction in database. i.esql> select * from dual;sql> select count(*) from dual;SQL*Plus is the comma...

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Aug 27th, 2007

Actually Oracle is made for query purpose not for FTS, and it obviously depends upon your requirements. In FTS oracle server process reads all the blocks concerned with the table and it is not so when...

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

Depends, if you want certain columns then why to query whole data. bcoz it involves more IO, network traffic and many other things

Answer Question  Select Best Answer

indifa

• Sep 4th, 2007

Select * from dba_objects where owner = 'GL' and object_type = 'TABLE'Change GL to AP and AR for respective table info.

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

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

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

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

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

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

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

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

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

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

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

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

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

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