1,135 Topics
 | |
| | Hi guys, I would like to know is it possible to connect and create databases locally on my Mac or even windows? using Oracle SQL Developer. I have installed Oracle SQL Server with XAMMP but this doesn't seem the correct way. Hope someone could help.  |
| | How can I learn oracle easily? what are the softwares required for testing & running oracle code |
| | I am using GUI in netbeans to create a combo box. I want to import all data of a column from database dynamically not manually to a combo box.  |
| | Please help. I try to run a simple Oracle query using the Xmlelement on Toad and SQLPlus and obtain an Access Violation error in Toad, while SQLPlus runs for a while before returning an End-of-file Communication File chanel error indicating its disconnecting. Is there setup required to use this function? … |
| | hi what is the query to fetch duplicate records in oracle table.  |
| | Hello everyone, I want to create a project in oracke. So can anyone help me how to configure PHP and ORACLE after installation of XAMPP ??? |
| | HI Friends, SQL> edit; SP2-0110: Cannot create save file "afiedt.buf" how to fix this problem. |
| | I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line. select revertrsn from LN08PENm where aano in(754,870,1136,1138,1139,1140) the data coming in the row that I am retreiving is like this: As … |
| | Hello guys, Do anyone know how to write recursive SQL statement for hierarhic output places from next table: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I was looking for alot of tutorials but didn't find anything useful. Any help is the most welcome! Regards, TP |
| | Dear Experts,I want to know how i can sync tables in sql server 2005 and oracle 11g tables. Table structure will be same in both server (sql server and oracle). I would like to prefer some tools available either in oracle or sql server.Thankspardeep  |
| | Hi all, I'm unable to get the below update SQL to run in Oracle, it's giving me th below error ORA-00933: SQL command not properly ended. Any help appreciated. UPDATE PDR.PH_Family_Match_by_Chassis a SET a.Launched = 'Y' INNER JOIN PDR.domCHASSIS ON a.chassis_id = PDR.domCHASSIS.chassis_id INNER JOIN PDR.domCHASSIS_MODULE ON PDR.domCHASSIS.chassis_id = PDR.domCHASSIS_MODULE.chassis_id …  |
| | Hi guys ! I am newbie, I have downloaded oracle 11g release 2 but i don't know where to start and how to connect C# program to database. I want to write simple program of username and password in which I it stored in database. And also maps the username … |
| | hi i want sql query to insert encrypted passwrd ?? foreample if user password : 123456 what is the sql query to insert it incrypted |
| | hello, I am going to create a project which is having multiuser configration, So i decided to take vb.net as frontend and oracle as backend. So the database will be on server and all client willhave software installed. Questions are : 1. Do i need to install oracle in all … |
| | how to get values from other table to update table |
| | How can we update one table with the values of other table in oracle. i have entity table with entityid and entityname and template table with templateid and templatesk sofar entityid is getting values from templatesk but now it should get from templateid .how can we do this.. update statement … |
| | Hello everyone, I have a PHP form that connects to an oracle DB and should send data to the database when the form is submitted, but I can't figure out why it's not loading any of the data into the database, everything seems to be correct (though this is my … |
| | hi friends, i am using oracle 10xe edition, when i use "select * from tab" in between other table name i found "BIN$VAmBblokS5GK+8YXdhI5EA==$0" give me tips to delete this. thanks for your time. |
| | Please help! i can't connect codeigniter to Oracle I am trying to connect Codeigniter to Oracle 11g, here are my settings Settings in database.php: $active_group = 'default'; $active_record = TRUE; $db['default']['hostname'] = "//localhost/"; $db['default']['username'] = 'xxxxxxx'; $db['default']['password'] = 'xxxxxxx'; $db['default']['database'] = 'orcl'; $db['default']['dbdriver'] = 'oci8'; $db['default']['dbprefix'] = ''; $db['default']['pconnect'] = … |
| | hello. i got a project to do using oracle pl/sql and i want to add a interface (preferably, web) so there aren't just some plain sql scripts. some text boxes, buttons, etc. so it looks nice :D. any suggestions? thank you. |
| | Hi, I have a string like this: ABC_STRING_DEF_GHI_JKL. Where the "STRING" part is constant. I am trying to get its corresponding regex pattern. Something like %_STRING_%_%_% So far I managed to get to this point: SELECT 1 FROM DUAL WHERE REGEXP_LIKE('abc_STRING_def_ghi_jkl', '(^(\w[^_])+)_STRING_([^_]+)_([^_]+)_([^_]+)$'); It's not really working, so if you have … |
| | Hello, I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format: Case CASE_ORDER MANAGER CURRENT_MONTH_CASES FISCAL_YEAR_CASES ------------------------------------------------------------------------------- case_1 1 John 15 84 case_1 1 Jeff 10 80 case_2 2 John 20 90 case_2 2 Jeff …  |
| | I am new to sybase. I came to know that i can take contents of a sybase table into a text file using an option called BCP Can anybody here explain how to use BCP in sysbase |
| | CREATE OR replace FUNCTION fn_findraise (dept_in IN VARCHAR2, salary_in IN FLOAT) RETURN NUMBER IS salaryraise NUMBER; BEGIN IF dept_in = 'MIS' THEN salaryraise := salary_in * .10; ELSIF dept_in = 'SALES' THEN salaryraise := salary_in * .15; ELSIF dept_in = 'HR' THEN salaryraise := salary_in * .20; END IF; RETURN … |
| | hey I have table that has date column and I want to select just all the sales that hapen in the first three month between 1/1/2012 to 30/3/2012 How I am able to do this select query ?? |
| | I did not really understand the benifit of the alias clause... this was in the w3shools tatourial with alias SELECT po.OrderID, p.LastName, p.FirstName FROM Persons AS p, Product_Orders AS po WHERE p.LastName='Hansen' AND p.FirstName='Ola' with out alias SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName FROM Persons, Product_Orders WHERE Persons.LastName='Hansen' AND Persons.FirstName='Ola' why we … |
| | I have a trigger(that prohibits the attribution of more than 10000 dollars to a worker that is not manager nor president) that i want to modify. CREATE OR REPLACE TRIGGER restrict_salary BEFORE UPDATE ON EMP FOR EACH ROW WHEN (new.sal > 10000) DECLARE job ename.job%type; BEGIN select job into job …  |
| | Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from … |
| | Hi everyone! I am pretty much new to Oracle it has only been 3 months or so I guess and I have a bit of a problem now. I'm running a query which will display the downtime of a machine. It will display the Start/End Time and its difference. The … |
| | hi guys can anyone explain to me what the codes in line 5 and 6 do? How does the WHERE works in those lines? Any explanation would be truly appreciated. Thanks in advance. SELECT LAST_NAME ||', '|| FIRST_NAME AS "NAME" FROM EMPLOYEES E, (SELECT JOB_ID, MAX(SALARY) SALARY FROM EMPLOYEES GROUP …  |
The End.