How do I reverse a dtring in Oracle without using PL/SQl and without using the reverse function??

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Apr 13th, 2012

Are you looking for something like this?"plsql function revstring(instring varchar2) return varchar2 is rstring varchar2(750) := ; iCnt pls_integer; begin for icnt in reve...

Answer Question  Select Best Answer

1) How to create login page in oracle 10g forms.

2) How to create an exe file of oracle 10g database

Sarat Teja

• Jan 5th, 2013

The login credentials will be requested at the time when you run a form on runtime of developer suit, that particular fmb/fmx is usually known as the login form or the master form from which a menu mo...

Answer Question  Select Best Answer

In which scenario we can use primary and unique key in same table???????

abinay

• Oct 6th, 2012

the combination of unique key and not null key is called primary key. In a table we use only one primary key.It is unique,it cant allow the null values. UNIQUE key ,in a table we use more than one un...

Answer Question  Select Best Answer

Explain the difference between object view and relational view.

Diptiman

• Dec 21st, 2015

A "Relational View" is the projection of the data using simple relational tables like: CREATE OR REPLACE VIEW relational_view (employee_name, department_name) AS SELECT employee_name, department_na...

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

Mukesh

• Jan 20th, 2006

The size of controlfile depend on 5 different parameter at the time of creation of database.MAXLOGFILEMAXLOGMEMBERSMAXDATAFILESLOGHISTORYMAXINSTANCE.

Answer Question  Select Best Answer

Asim Jamal

• Jun 6th, 2006

   We can add a signature to a database by using LONG datatype.and can use in the report as required.  

Answer Question  Select Best Answer

Kanchan

• Mar 7th, 2006

In Oracle with PLSQL language implemented in D2K, we can use principle of INHERITANCE by using Libraries which is oops concept. 

Answer Question  Select Best Answer

Murugavel

• Aug 29th, 2006

Hi,I hope the difference is:execute() - returns boolean value (true implies that the query returns some Resultset, where false is not)executeUpdate() - returns integer value (the value implies number of rows affected)bye..

Answer Question  Select Best Answer

Suresh

• May 11th, 2006

DISTRICT   STUDENTNO  STATUS---------- ---------- -EG         1          PEG    ...

Answer Question  Select Best Answer

Arijit Basu

• Oct 7th, 2006

How can I call a report from a from in d2k?

Answer Question  Select Best Answer

srinivas devulapalli

• Sep 12th, 2006

Toad Tool exist in not only importing or exporting the data but also creating the database objectthe object etc

Answer Question  Select Best Answer

Nishanth

• Aug 17th, 2006

For ORACLE to display the amount of time it takes to execute a statement or procedure in the SQL window you need to set some environmental,in this case you have to execute the following statement...

Answer Question  Select Best Answer

developer

• Oct 11th, 2006

Hi Mukund,Developers and DBAs use these tools to get the best performance out of their applications. The execution plan is made available to you in the form of rows inserted into a special table calle...

Answer Question  Select Best Answer

Peter Wegner

• Nov 5th, 2006

You can use the oraenv script to ensure that user accounts are updated and to switch between databases.

Answer Question  Select Best Answer

Mano

• Sep 26th, 2006

Hi,select max(nvl(empno,000000))+1 from empU have to wrie this in pre_text_item trigger of the empno item.Check and confirm.Thanks and bye

Answer Question  Select Best Answer

sudheer

• Oct 17th, 2006

Hi,  We can't use relational operation in decode.where as we use in case stament.

Answer Question  Select Best Answer