Oracle

Oracle 6i Log in - User-name & Password

What is the user-name and password of Oracle 6i to Log in?

Oracle9i error message on installation

while installing oracle9i in laptop i a getting message jrew.exe stoping program( i am using window vista

How to retrieve picture from the database into form through LOV

I have two question 1) How to retrieve picture from database into form thought SELECT statement. I am using oracle 10g form developer. I create a form which contains many fields such as Passport No. Gamca No. Sr. No. etc as shown in upload picture. Picture and other field's data save into...

Equivolent HLOOKUP using SQL

I am a beginner at SQL... I've come across a situation maybe someone can help me out. I have a table with the following structure: bkt_id am bkt_101 bkt_102 bkt_103 ... bkt_228 bkt_101 $100 $100 $20 $0 bkt_102 $50 $100 $20 $0 ... I want to compare am with the proper bkt_n...

Database modeling question

I have a quandry on my hands. Another developer and I are designing a replacement for an older custom application, and we're deep into data modeling. We can't agree on a solution. More precisely, I think it should go one way, he thinks it should go a different way, and I can't quite prove that...

Filemaker Pro 9 ODBC ORA-00936 error

I can see all of my tables in an Oracle dbase. For two of them, I can see the actual values. On another table, I can see the fields but the actual values return with an [Oracle] ORA-00936: error. Why can't I see the values for this 3rd table?

paper size parameter report 6i

who add-parameter of paper size on report 6i???

Oracle new versions

I'm working with a IT company. may i know the new version for oracle

About Oracle Forms & Reports

I am beginner of forms and reports.i need basic coding site for forms and reports pls anyone help me

Oracle- Parsing data in a specific row into a temp table

I have used select text from dba_views where owner = 'Something' and view_name = 'Something'; I get back a row with the word (MEMO) in it. However that row contains a lot of text when clicked on. Such as something like SELECT /* SCCS Rev 1.1 10/14/2002 by Blah SCCS Rev 1.2 10/24/2002 ...

Oracle- Source Code for Tables and Views cannot find

Hey, I am working on some coding to find a certain phrase with a number like (SCCS Rev 1.13) in the comments within procedures, tables, views, packages, etc. It works for everything except Tables and Views. This is because i am using Dba_source which does not include the source code for table or...

What steps are required to created OpenLdap server for Oracle 9i?

Please guide me how to configure an Openldap server for Oracle 9i database. Your kind guidance would be a great help and be appreciated.

to calculate last business day for each month for corresponding to any given date for last five years

Hi , i have created a function to calculate last business date for each month for 1 year . Now, I want to modify code to find out last business day for last 5 years. Please suggest me what changes i need to made in code . CREATE OR REPLACE FUNCTION LAST_MONTHLY_BUS_DATE_FOR_YEAR (P_DATE in...

How to convert character report to bitmap

Hi, I want to convert oracle 10g character (.txt) report to bitmap (.pdf) in A4 size. The existing character report is 13inches X 11inches.

store image from a directory into oracle database using sql

i have a directory containing 1000s of photos which i have to upload into oracle 9i db. i need to use only sql plus for this. i want a simple material to upload all those photos..

Best platform for this Oracle application mix

We have decided to go for Oracle E-Business Suite ERP for Financials, HR and other business processes and Siebel for CRM along with Oracle SOA suite and Oracle BI suite. I need advice how to select the operating system platform for various application and Oracle database servers. We are thinking...

How to change Oracle hostname

My Oracle database control is pointing at the wrong hostname. Where do I change that? Thank you. Moderator Note: This is a submitted question

Sending logs using Oracle Data Guard

We have configured primary and physical standby databases on two different machines. We want to ship the logs using Oracle Data Guard from primary to physical standby databases so that the two databases are always in sync. Please inform what are the minimum network permissions required to allow...

How to uninstall OracleserviceXE

I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

ORA-12541:TNS:No Listener

When I want to open the global database from 'the Oracle Enterprise Manager Console Standalone' menu in Oracle 9i, then the 'ORA-12541:TNS:No Listener' message occurs. It can't open the database. It also needs the user id & password. What should I do? Moderator Note: This is a submitted question