Sign In | Register Now About Bytes | Help | Site Map
Connecting Tech Pros Worldwide

Oracle Forum

Oracle Database (Oracle) RDBMS - Ask questions about installation, SQL, PL/SQL, objects, XML, triggers, joins, stored procedures, errors, queries, reports, storage, connections, tables, backups and more.
September 9th, 2008 msquared (Administrator)
Special guidelines for Oracle forum.
Post Reply? | Posted by: debasisdas | Last post by debasisdas, 467 days ago
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
2 Replies | Posted by: chetah | Last post by debasisdas, Yesterday
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
7 Replies | Posted by: vin2sara | Last post by debasisdas, Yesterday
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.
1 Reply | Posted by: Parul Bagadia | Last post by debasisdas, Yesterday
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...
1 Reply | Posted by: didajosh | Last post by debasisdas, 3 days ago
Hi, My table is... more »
Dynamic Sql
4 Replies | Posted by: orajit | Last post by orajit, 4 days ago
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
3 Replies | Posted by: AdusumalliGopikumar | Last post by debasisdas, 4 days ago
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
5 Replies | Posted by: hussaintal | Last post by hussaintal, 5 days ago
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
Post Reply? | Posted by: dev2008 | Last post by dev2008, 5 days ago
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
Post Reply? | Posted by: vamsioracle | Last post by vamsioracle, 6 days ago
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)
1 Reply | Posted by: jackad | Last post by Dave44, 8 days ago
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
2 Replies | Posted by: kranti116 | Last post by kranti116, 9 days ago
I have the following table contents: ID kEYWORD -------- ---------------------- 1 AB 1 AC 1 AD 2 XX 2 ... more »
oracle functions
1 Reply | Posted by: RPPORTER | Last post by debasisdas, 9 days ago
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
4 Replies | Posted by: greenMark | Last post by convertin, 9 days ago
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
2 Replies | Posted by: davidson1 | Last post by convertin, 9 days ago
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
1 Reply | Posted by: shamszia | Last post by convertin, 9 days ago
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
5 Replies | Posted by: truezplaya | Last post by truezplaya, 10 days ago
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
2 Replies | Posted by: datanut | Last post by debasisdas, 10 days ago
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
3 Replies | Posted by: Parul Bagadia | Last post by debasisdas, 10 days ago
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
2 Replies | Posted by: chinni409 | Last post by debasisdas, 10 days ago
hi guys,,,,,,,can any one say what does ' i ' & ' g ' stand for...in oracle versions 9i, 10g......... more »
Any oracle formatter or beautifier?
3 Replies | Posted by: sudhaMurugesan | Last post by debasisdas, 10 days ago
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
2 Replies | Posted by: cookiejar | Last post by cookiejar, 11 days ago
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
1 Reply | Posted by: bittu rajasekhar | Last post by r035198x, 12 days ago
what is difference between oracle and dbms,sql and isql more »
performance issue on report
Post Reply? | Posted by: julietmachiwa | Last post by julietmachiwa, 13 days ago
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
1 Reply | Posted by: WilliamJohn | Last post by roykeane, 13 days ago
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 »

Latest Articles: Read & Comment
Top Oracle Forum Contributors