1,488 Topics
 | |
| | I'm having a really hard time trying to figure out how to make the following search: "Find the sellers specialized in selling cars of the year (They can only sell cars produced during a specific year, example 2010). The tables I have are: Seller: {[U]Seller_Id[/U], Name, City_Residence} Business: {[U]Car_Id,Seller_Id[/U],Year_car_Produced, Business_Date, … |
| | Hi, I have a table in Oracle. Here is the table. [CODE] SQL> select * from test; SDI NAME ---------- --------------- 123 Tapas 345 PradEEp 567 Jagadish 789 Giri [/CODE] I want write this data into a CSV file. I tried this but i am not able to redirect or …  |
| | Hi, I m very mew to the oracle. I want to teach transaction and locks to the diploma student. I searched so many examples of these topics from the Google Search engine, but fail to search simple and short example. I understood the topics, but can't find simple example. Will … |
| | there is a procedure which have 6 input parameters, 1 for each. All input parameters are of type char. i need to convert those into respective datatypes and insert the data in table. how to convert char to date and int datatypes? |
| | Hi, we have pl/sql objects.for some pl/sql objects we found the object names in the scheduler list to run it.But we didn't found the some objects to run the jobs. the scheduler contains Object list. if you select one object and click on submit button then it will show u … |
| | Hi everyone. I want to create a crawler with perl and run it on crowntab. The program should use DBI and DBD::Oracle to insert data into my database. When crontab runs it, I get the following error in my mail box. Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open … |
| | Hi, I have one Oracle standalone procedure.In this am doing truncating the data and loading the new data into the target table. The issue is , I want to know whether the table is callable from other procedure,if it it callable I want to know the Procedure or Packages list. … |
| | I HAVE LOADED ORACLE 8i ON WINDOWS XP. IT HAD LOADED SUCCESSFULLY AND I HAD WORKED ON IT. BUT ON NEXT REBOOT WINDOWS IS NOT ABLE TO START THE SERVICE CALLED OracleServiceORCL. WHEN I TRY TO START IT AGAIN IT ENDS WITH AN [quote] ERROR:- Could not start the OracleServiceORCL … |
| | Relatively new to VB.NET coding. Am creating a pretty simple console application that needs to insert over 50,000 records into an Oracle table (OleDB connection). I tried 3 different methods so far: Individual INSERT, insert using a dataset, & using INSERT ALL (commit every 25 records due to # of … |
| | Greetings, I'm having some trouble creating a trigger that, before I insert something in a table, it resets an existing record field to 0. Example I have in the table a field named "Name" and another named "Active". Each field has a diferent ID The last entry of a "Name" … |
| | I have a problem whit load of xml file into Oracle using StringBuffer. I get a java.sql.SQLException error “setString can only process strings of less than 32766 characters”. My problem a cure when I try to bind the CLOB with the prepared Statement in the StringBuffer. There are no problem … |
| | hi guys, thanks for viewing my thread. Being in oracle for database administration is something awesome. I would like to know on how a bulk of documents in .txt file could be cluster using oracle 10g. The documents all are report which are contain Speaker Name , Report ID , … |
| | |
| | I have heard that oracle 11i is an ERP,i want to know that what is an ERP??? Is it a database or something??? |
| | |
| | Hi, Is there anyway to insert/add a new column between two column in a table without deleting any other column??? |
| | i want the java methods or the mechanism which will work as that of COMPOSE and DECOMPOSE functions in ORACLE/PLSQL. please help me out. thanks in advance.. COMPOSE-ORACLE [CODE]compose('o' || unistr('\0308') ) [/CODE] would return ö DECOMPOSE-ORACLE [CODE]decompose('é') [/CODE] would return 'e´' |
| | I want to find out days gap between two dates excluding sunday. How can i do this in oracle. Please help me. |
| | hi can any one tell me how to export and import a table in oracle 9i? please be brief. |
| | Hello fellows. I'm creating a new oracle database table. My table name is [B]tblTest[/B]. But it returns an error code ORA-00903: Invalid Table Name. I dont know why this happen. I think the table name is right. But what is the problem actually. [URL="http://img820.imageshack.us/img820/3946/nonametgm.jpg"]http://img820.imageshack.us/img820/3946/nonametgm.jpg[/URL] Thank you. |
| | [CODE]I am making a website in which i have to add video tutorials. I was thinking of making a database in which i could put all my videos and connect it to the webserver. But i dont know the right procedure to do it. Can anyone help me please?[/CODE] |
| | Checking data for login form with oracle xe database  |
| | Hi, I am converting one query from SQLServer to oracle i get some error related to Exists clause. what i need to do. Date related change i tried in oracle. all subquery return row and i got error on first line. Thanks in advance [B]This is the SQL Server Code:[/B] … |
| | Is there any free migration tool for mySQL to Oracle ?  |
| | I would like to know if I drop a constaint on a column whether Oracle will automatically change other constraints that involve that column? The reason I ask is because for two days in a row when I dropped constaints on a column that related constraint had the very same … |
| | hello i m anup i want to know about what are steps to create database in oracle8i which is then used java program.in detail.plz help me |
| | What is a transaction and how transaction is managed in DBMS? |
| | create or replace function vdep (d departments.department_id%type) return boolean is b boolean; e departments.department_id%type; begin select department_id into e from departments where department_id = d; if e = null then b := false; else b := true; end if; return b; end; / set serveroutput on variable b boolean begin … |
| | Please advise me on any good performance monitoring softwares for Oracle Database. Budget is no issue. I want to find and fix performance bottlenecks in Oracle Database (Oracle 9i Rel2), as well as generate graphs on statistics collected over a period of time. At present I am evaluating: 1) Spotlight® … |
| | Hi, I want to take backup of all my tables in my system and i want to use in other system.Tell me how to take back up tables in oracle 9i and how to import or use those backup table in another system??? |
The End.