1,135 Topics
| |
just installed SQL Developer 4 and I'm using Oracle Database 11g. I want to execute multiple insert into statements in the worksheet at once. That works fine if I copy paste via command line of SQL but in Develop 4, only one row is being inserted at a time. Is … | |
Java vulnerabilities have hardly been out of the news during the last year. Here at DaniWeb we've covered a number of the stories as they surfaced: [Java in the cross-hairs: the security debate rolls on](http://www.daniweb.com/software-development/java/news/445532/java-in-the-cross-hairs-the-security-debate-rolls-on), [Is Java 7 still insecure? Oracle Patch doesn't fix underlying vulnerability](http://www.daniweb.com/software-development/java/threads/432479/is-java-7-still-insecure-oracle-patch-doesnt-fix-underlying-vulnerability), [Update my insecure Java … | |
hi I had a question in an exam that asked for the code of a trigger that cancels a transaction if a query result doesn't meet a condition in oracle database. is it possible? I am googleing but I can't find an answer thanks | |
hi all i want to select data base of the value of the cursor but i donot know how to do it . thanks in advance | |
Is it possible to use Kohana ORM with MySQL AND Oracle DB? More wider questions is is it possible to use two different databases (RDBMS) with Kohana? | |
update mytable set mycolumn = trim(mycolumn) I am using above query where mycolumn is of type char. It trims the leading blank but not trailing. I tried update mytable set mycolumn = TO_CHAR (trim(mycolumn)) But it didn't help either. Can anyone help here? | |
Hi, I am using windows 7 sp1 32bit, try to install "Oracle 11g release 2" I am getting below errors and not properly installed help me to solve this errors thanking you file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em.ear file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em\em.war file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not … | |
Hi, I am trying to generate a spool file through below anonymous block in order to find out views on a particualar table. declare cursor c1 is select view_name,text from users_view; rt c1%rowtype; begin open c1; loop fetch c1 into rt; exit when c1%notfound; dbms_output.put_line(rt.view_name || '|' || rt.text); end … | |
[This](http://docs.oracle.com/javase/tutorial/essential/concurrency/deadlock.html) is the example i was looking at. The docs say that trying to access the bowBack() method is creating the deadlock , but im new to threads , and i really dont understand why this is happening. In need of some guidance here... | |
i want to ask you when i execute the following sql statement SELECT account_identifier,least(to_number(part_1)),least (to_number(part_2)) FROM TEST5 ; i get the following error ORA-01722: invalid number 01722. 00000 - "invalid number" you should know that when i execute the following sql statement SELECT account_identifier,to_number(part_1),to_number(part_2) FROM TEST5 ; it works fine | |
I have created four tables in apex oracle and I also need to create four statements which display information from all four tables or just a few of the tables, I have tried writing up advanced statements myself but they are not advanced enough, can someone please help? | |
weather oracle forms language is usefull in mnc's... how will be its job openings | |
Here i am trying to load data from TABLE1 to TABLE2. The requirement is to consider those records in the TABLE1"where TABLE1.COL1=TABLE1.COL1 (OR) TABLE1.COL2=TABLE1.COL2" As a single group and insert into TABLE2 with COL3 with a unique value for each group thus identified. TABLE1 ~~~~~~ COL1 | COL2 1 | … | |
I have desided to go in database line... many people suggested to go for oracle developer course(sql,pl/sql,oracle forms) and do DBA after getting placed in a company as a oracle developer.. weather oracle developer course will be usefull to get a job as a fresher... else what will a better … | |
Dear Experts, I am facing following problem with oracle 11g while programming. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor System has four database is connecting through sql developer successfully but ohters are not connected. When i am again creating same database for correcting error it … | |
I am stuck on the final part of the query, I know that this thing is easy, but I am out of ideas now, so sorry for this. I have prepared a query like this: SELECT A.projectName as PARENT, (select COUNT(*) from PSPROJECTITEM WHERE PROJECTNAME = A.PROJECTNAME) parentprojecount, B.ProjectName as … | |
i'm new to web designing. i'm planning to create the website which will store user information in oracle database. my questing is is it possible to connect oracle 10g to web page(form)? need tips.. | |
Hello DBAs, Can any one guide me how can i get the last modified date(insert/update/delete) of a table? Regards, B. Mantri | |
Hi, I typed the below code in oracle 10g express edition. [CODE]SELECT emp_id, last_name, salary, dept_id FROM employees WHERE emp_id = &employee_num [/CODE] I get an error; ORA-01008: not all variables bound Can you pls help? Thanks. | |
Hello, I need description about ORA error 26759, i tried to check decumintation for cause or action but with no luck, would anybody help me diagnosing why i saw this error on my 11g Oracle DB. Thank you in advance. | |
Hi, I am new to oracle. I have this following query : SELECT TYP_CD, SUM( INVC_AMT), trunc(ALLOC_RUN_DT) as "Alloc_Date", MIN(ALLOC_RUN_DT) as "Minimum_Time", MAX(ALLOC_RUN_DT) as "Maximum_Time" FROM allocation_header group by TYP_CD, ALLOC_RUN_DT order by TYP_CD, "Alloc_Date" and the sample output I get is : TYP_CD INVC_AMT ALLOC_RUN_DT Minimum_Time Maximum_Time 01 20520232.31 … | |
I'm not sure if this is the right place to ask , but is this erd valid? Or is it unacceptable? Thank you for any help. | |
Am trying to add a constant column to the select query which is quering an inner query. Need your help with the query. select *,'1' as flag from ( select ROW_NUMBER() OVER (PARTITION BY e_id ORDER BY birth_date DESC) as rn,wh.birth_date,e.*, xy.m_id from employee e inner join table2 xy on … | |
what is the SQL command (Query) to create category and subcategory in oracle thanks for your time. | |
Hey everyone I need some urgent help please. I don't know how but I need make a Time Dimension of an Oracle Table using c#. What needs to happen is: -I want to use Order_Table's Date Column to Create a new table Time_Dim with columns OrderID, Year, Month, Week, Day. … | |
Hi everyone I need help please. I need to create a Time Dimension of an Oracle Table using C#. I have no idea how to do it. Any Suggestions? Thanks in Advance | |
Hi All, I have two machines, one Solaris and another Linux. On my Linux machine , i have Oracle10g installed and have one instance(say firstInst). I have Oracle 10g installed on Solaris also. When i try to connect to this firstInst, from Solaris , i get error like *sqlplus sys/sys … |
The End.