September 9th, 2008
msquared (Administrator)
|
Special guidelines for Oracle forum.
Hi all
Every time you post any code for reference of experts in this forum please take care to explain your problem in details and take specially ... more »
sticky
|
|
Sql/oracle format
I am using a table called Employees. I want to display:
Smith 7898
John ... more »
|
|
how to get present time and date???please its urgent
Hi,
Can anyone send a query to get present date and time ??I used dateformat method ,but i am not getting that.please its very urgent to... more »
|
|
Storing image in table.
Hello,
For my project in Oracle, i need to store an images in 2 tables,... actually my front-end in the project is VB amd oracle is the back-end; so... more »
|
|
How to put IF conditions on COLUMN NAMES...
|
Dynamic Sql
I have written code in Dbms_sql form
Can anybody tell me how to use dynamic sql for below code ,..
If possible please rewriie below code in dynamic... more »
|
|
Data Being Populated
Hi All,
Can anybody tell me the solution for the below senerio.
I have a set of tables and they have been populated from different feeds... more »
|
|
reading text using client_text_io utility
We are using client_text_io utility (webutil.pll) to read a text file and insert specific fields into table in the database
Problem: firstly the... more »
|
|
Search for tablename and column name for one value across 1 database
3 Replies |
Posted by: daves1
| Last post by AdusumalliGopikumar, 5 days ago
Hi,
I want to search for the table name and column name that have the value "ABC" .
Any idea with where i could start with this one?
thanks. more »
|
|
Retrieving org id through unix shell
Hi,
I am using a shell to retrieve the org_id of the operating unit from oracle. is there any particular syntax for org_id like u have REQID for... more »
|
|
Discoverer Apps Registration
Hi all
I ahve registered a discoverer report in apps. The process is complete. I navigated to the right menu and when i click the report it goes to... more »
|
|
Oracle 10g on Windows Server 2003 (32-bit)
Hi,
I've been trying to install Oracle 10g (10.1.0.2) onto wa Windows Server 2003 (32-bit) platform. The basic installation works fine but when I... more »
|
|
concatenation of rows
I have the following table contents:
ID kEYWORD
-------- ----------------------
1 AB
1 AC
1 AD
2 XX
2 ... more »
|
|
oracle functions
I am a newbie to Oracle functions and need help with a function. I am trying to create a report to show only those accounts/customers with an... more »
|
|
Migrating From Access to Oracle
Can anybody let me know how to migrate data from MS Acess to Oracle. I tried with a PL/SQL procedure. But it didn't work. Are there any in-built... more »
|
|
How to transfer data from oracle dump file to Excel Sheet
Hai friends,
In our college we have oracle database , i need the old records for testing my project , and the old records are in dump file. Now i... more »
|
|
extract data from dmp file
I exported data using Export Utility. Now import utility is not working with this .dmp file. i've tried using nxtextract, but it limits rows to 5000.... more »
|
|
Auto Increment
Hey all
I currently have an application in vb that reads and writes to a oracle table.
My problem is getting it to write to the table as i wish to... more »
|
|
Procedure - Dates Between
I need to make a table (tabel B) using table A. THANKS!
My current table
MBR_SID MinD MaxD
A 1/1/2008 1/10/2008
... more »
|
|
Subtraction of dates
For certain purpose ; i need to subtract two dates in sql can i directly write a sign of subtraction or will i have to do sth else? more »
|
|
oracle versions
hi guys,,,,,,,can any one say what does ' i ' & ' g ' stand for...in oracle versions 9i, 10g......... more »
|
|
Any oracle formatter or beautifier?
Hello everybody,
I need oracle formatter as similar to sql beautifier available online. Any body can say some web sites regarding this... more »
|
|
New Member
I am Crystal report developer that uses Oracle as my database. I am not an ORACLE developer. I am a novice. I have been tasked to get the user-id... more »
|
|
difference
what is difference between oracle and dbms,sql and isql more »
|
|
performance issue on report
After I re-build my indexes I am now having problems/ reports are now taking time in spooling and also in forms to populate LOV its also taking time... more »
|
|
Oracle Forms Migration 2.4 to 10g
This is regarding conversion of oracle forms 2.4 to forms 10g as we are in the process of converting our forms application in 2.4 to forms 10g for... more »
|
|