What are the data types in oracle?

MahanamShakyamuni

 Profile Answers by MahanamShakyamuni Questions by MahanamShakyamuni

• Nov 19th, 2010

In SQL, there are mainly varchar2, char, number, date...then each of them has subtypes like number has integer, real etc..Following website gives all details:For SQL datatypes refer:http://download....

pradeepnagaraja

 Profile Answers by pradeepnagaraja Questions by pradeepnagaraja

• Nov 18th, 2010

Different data type used in Oracle are number, char, varchar, varchar2, clob, blob, long.

Answer Question  Select Best Answer

for example i have 50 columns i filter the nulls in FBE.in filter by exp a parameter select_exp .what function is used .how to write the condition .i take a example on emp file(empno,ename,sal......).how to write the condition in filter by expression?

G

• Jan 13th, 2012

U can use : " " to filter null values using code.
Eg:
with worksheet.range("A1:B10")
.autofilter 2, criteria1: ""
end with

shiv

• Jan 2nd, 2012

IS NOTNULL(salary)

Answer Question  Select Best Answer

How to convert rows in column using SQL in Oracle;
for example
sl_no
1
2
3
4
output is 1234;

How to convert one column value into rows using SQL
for example
employee_name
Kumar

output
K
u
m
a
r

Megamind

 Profile Answers by Megamind Questions by Megamind

• Apr 14th, 2014

We can do it via pivot keyword..... it will change the row into column.. its simply a pseudo column

Kandavel Durairaj

• Nov 8th, 2013

Using LISTAGG. Read the oracle documentation for more info.

Answer Question  Select Best Answer

Hi guys try this query

If any student fails in one subject also his result should be Faile r else Pass
condtion is(marks>=40 "PASS" marks

nancy

• Jul 19th, 2016

Code
 

SOnali

• Jun 29th, 2016

Select Name,
when Min(Mark)>40
Then Pass
Else Fail
End
From TableName
Group By Name

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

NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

NO DATA FOUND: Is an exception which is raised when no rows are retrieved from the database in a SELECT statement, then PL/SQL raises the exception NO_DATA_FOUND.%NOTFOUND: is a Boolean attribute that evaluates to TRUE if the most recent SQL statement does not affect any rows.

syam sundar

• Aug 17th, 2007

NO DATA FOUND is an exceptionWhen your?SELECT INTO?statement?returns no rows that time an error raised by oracle. The error is ORA-01403 NO DATA FOUNDWhereas %NOTFOUND?is a?cursor attributeIt ret...

Answer Question  Select Best Answer

LOOPSELECT num_credits INTO v_numcredits FROM classesWHERE dept=123 and course=101;UPDATE studentsSET current_credits=current_credits+v_numcreditsWHERE CURRENT OF X;END LOOPCOMMIT;END;

aravindpurohit

 Profile Answers by aravindpurohit Questions by aravindpurohit

• Apr 4th, 2008

When referencing the current row from an explicit cursor, we use                           'WHERE CURRENT OF'.  it allows ...

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

The WHERE CURRENT OF clause is used to reference the current row from an explicit cursor.

Answer Question  Select Best Answer

No. A function has to return a value,an OUT parameter cannot return a value.

ashvini

• Apr 24th, 2006

Yes ,function can return a value but it is not a good programming practice

indrajit

• Nov 9th, 2005

Yes. Functions can have OUT parameter.

Answer Question  Select Best Answer

Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screenCan be row level or statement level No distinction between row level and statement level.Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.Can be fired from any...

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

Database Trigger: We can't invoke a Form Trigger in DatabaseFrom Trigger: We can invoke a Database Trigger in Forms

Mohit Dhamija

• Jul 3rd, 2006

Even 'Form Trigger' can be fired before and after the event. ex- Triggers like Pre Block / Pre Record / Post Block / Post Record ..

Answer Question  Select Best Answer

Nicsmart

 Profile Answers by Nicsmart Questions by Nicsmart

• Mar 31st, 2010

• Use when working with an unbounded list that needs to increase dynamically • Use when you need to store in the database and operate on elements individually

paul

• Sep 2nd, 2006

Hi,Nested Tables are collector objects (only attributes, i.e. no behaviour defined), that can be re-used in the same way as a class in java or c++ (without  functions / procedures). In RDBMS...

Answer Question  Select Best Answer

Rajesh

• Jun 16th, 2006

253 is not prime, it is divisible by 11 and 23. So the ans. is 251.

Ravi

• Apr 29th, 2006

Hi Guys:Iam unable to follow ur discussion. why is it 251 and not 253. afterall we are finding the maximum (highest in value) prime number less than 255.Please correct me if Iam wrong.Thanks

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

nis1981

 Profile Answers by nis1981 Questions by nis1981

• Aug 3rd, 2008

Inorder to use UNION SET OPERATOR the datatype and the number of columns should match. Here you are trying to get the union of a character datatype and a number, hence you get an error.

Renuka Rajput

• Jul 29th, 2006

i would like to add one more point that not only datatypes but also structure of both the select statement should be same.if we write query asselect 1,2 from dualunionselect 1 from dualit will still results in error and the error isexpression must have same datatype as corresponding expression

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

Date and character literals must be enclosed within single quotation marks (' ');If a column alias contains a space, it should be enclosed in double quotation marks.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

double quote(") is used to give user defined column alias example:select empno , ename "employee name" from emp;this will print column heading as:  EMPNO       ...

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 28th, 2007

1. When you create more indexes on a table , for example  table A has 10 columns and you have create 8 indexes on that table. Then whenever you r going to retrieve data from that table each row o...

Sushma

• Jul 11th, 2007

3.If we have the null values in the column then we can not create primary key trigger on that column.4. It is an event that raised implicitly when you update the table.Regards,Sushma

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select salry from Hello h where 1=(select count (distinct salry) from hello where h.salry

maqsood

• Jul 10th, 2006

Select last_name from employeesWhere rownum

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

SAMADREHMANY

 Profile Answers by SAMADREHMANY Questions by SAMADREHMANY

• Dec 25th, 2012

G means Grid Computing..

Sundaresan

• Aug 29th, 2006

Grid computing

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 22nd, 2008

SELECT TO_CHAR(TO_DATE(11111,'J'),'JSP')||' DOLLARS' FROM DUALThis will work for the  values in  between 1 and 5373484 only.

Radhi09

 Profile Answers by Radhi09 Questions by Radhi09

• Feb 15th, 2007

HI Dev,Its working but can u explain it more clearly thanks,Radhi

Answer Question  Select Best Answer

shailendra nigam

• Jan 4th, 2007

hii am shailendraits my opinionoracle is based on RDBMS. its follow the 10-11 rules in Dr. E.F.Codd  but SQL Server is based on RDBMS. its follow the only 7-9 rules in Dr. E.F.Codd.

Manivannan Palanichamy

• Aug 24th, 2006

SQL - A RDBMS language, is ANSI std.Oracle - a database vendor/database server, which can run across multiple operating system, has number features than any other databases, which is hot in marke...

Answer Question  Select Best Answer