1,488 Topics
 | |
| | Hello All, I want to know how to sort ascending or descending varchar values. This is my field and values Filling_s_no varchar2; Table: Id Filling_s_no name 1 1.1.1 X 1 1.1.10 X 1 1.1.5 X 1 1.1.2 X 1 1.2.1 X 1 1.2.0 X Now I want to sort my …  |
 | Hi What is my misstake? I got error whwn I run my code! DECLARE V_num number := ‘&enter_an_integer’; V_test number; Begin V_test := mod(V_num,2); If V_test = 0 then Dbms_output.put_line(’even number’) Else Dbms_output.put_line(‘odd numbers’); End if; End; The error was 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a … |
| | can any one help to find out how to create a oracle app using oracle express edition 10g  |
 | Hello group, I've decided I want to take some classes in SQL, to better understand how to write queries. In looking online for where to turn to for this kind of training, I also see classes to prep for certification. I'm curious of what the value to my employer would …  |
| | Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to … |
| | Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter … |
| | Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of questions. I'll start simple (I hope). I've created my own tables (2) that have multiple columns of data that looks … |
| | HI, Am new to PL\SQL. I just want to fetch the 4 fields from employee table. how to do it? employee_ID, First_name, Last_name, total number of employees from employee table. i tried to fetch using count() function. but it is not giving the total number of employees. can anyone please … |
| | I currently wish to write a query to duplicate data in database while modifying one column. First of all, my database structure: table code CURCD NOT NULL VARCHAR2(3) CODE NOT NULL VARCHAR2(2) ITEM NUMBER(1) DSCPT VARCHAR2(20) The unique idx is the curcd,code,item. What I wish to achieve is duplicate data … |
| | Hello All, I have two schema called mater and transaction. In master one table called - BCC_TM_CITY In transaction one procedure called PR_GETCITIES. In this procedure table BCC_TM_CITY used like this select * from mater.BCC_TM_CITY; my problem is, recently I dropped the table and added again in master. After that, … |
| | I am trying to drop some data files to free up disk space. In order to do that we first need to know how to identify the data file that has 0 extents allocated. I am stuck at the arriving at the query that will show me the datafile that … |
| | below, I have create a table using oracle sql. How can I change so that number of credits for a course is always between 0 and 6. Any idea how can i do this? CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk PRIMARY KEY (COURSE)); |
| | below, I have created 4 tables using oracle sql. I want to change the code so that when deleting a student will delete all enrollments for that student. any idea how can I do this? # COURSES table # CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk … |
| | I am trying to write a function that will update a table, 'Orders'. The rows in this table will have Item, Location, Qty, SendDate, and EndDate (SendDate and EndDate are in 'yyyymmdd' format). The difference between SendDate and Enddate will need to be taken and spread the qty out by … |
| | A question..how can we store our nose and ear in data base?? plz reply.  |
| | Hi all! I'm new to Weblogic Server. I'm trying to see how sessions are persisted on Weblogic (For Load Balancing). From the official documentation I found that you have use Proxy Server like Apache or Oracle Http Server for in-memory replication(for load balancing), which will act as a proxy server … |
| | this is my latest class assignment, i would really appreciate some assistence with my pseudo code to help me in the right direction. my code skeleton is provided at the end of this post. Deque A double-ended queue, often abbreviated deque and pronounced deck, is an object with the following …  |
 | I'm trying to install CentOS on my Linux Mint desktop through Oracle's VirtualBox. The instalation screen says it's installing to sda1 and that's it's mount points are /boot -> 500 MB, / -> 5.02GB, & 614 MB. Is this safe or is there a chance this is going to mess … |
| | I just developed an android app having sqlite database so I just want to connect it to the oracle database server at the remote. Pls can someone guide me?  |
| | Hello, I have been trying to write a procedure that should select the user ID and display their names. Below is the code that I have written, however, when I try to compile it, there are errors. Please someone help me as to where I'm going wrong with this code. … |
| | Hello, I don't if it relevant to ORACLE because I cannot find MAGIC UNIPAAS. I received this formula from UNIPAAS developer, could you explain me what's the meaning of this formula? IF (AH_BL_Date+IF (Air Shipment,1,SUPP CI LEADTIME)='01/01/1901'DATE,'00/00/0000'DATE,AH_BL_Date+IF (Air_Shipment,1,SUPP CI LEADTIME))  |
 | Hi, can anyone please help me to find out a solution for the below mentioned problem?? While installing oracle 11g in linux on a remote desktop, failed dependencies occured when installing rpm packages [i want a soluion withou using yum software] [root@TomcatServer Server]# rpm -Uvh gcc-4.* warning: gcc-4.1.2-44.el5.x86_64.rpm: Header V3 … |
 | Hello Geeks; In the eve of new year i have some fresh topics for you. I heard that web is full of real life oop design samples and comprehensive object oriented design guides. Which sites would you offer or which tutorial sequence should i follow ??? PS. Of course other … |
 | |
| | While installing oracle 11g on linux an error occured,please give a soluion for that: The error is shown below.. [oracle@TomcatServer database]$ ./runInstaller Starting Oracle Universal Installer... ./runInstaller: line 92: 600 Segmentation fault $CMDDIR/install/.oui $* |
| | Hi everyone, Can any one tell me today's IT industries oracle certification is worth for freshers... |
| | What do you think about PL/SQL ? Is this a language worth learning for the feature along with SAP? |
| | Hi, i have two tables both one is partitioned and another is having a 3GB of data. I've added a composite index on both the tables based on the where clause, in the order it appears. The output of explain plan after gather stats shows that the sql is accessing … |
 | Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function … |
| | After Designing database--->Connection to database--->Data entered-->Data stored in database.My doubt is in which format data is viewed on the screen.(XML OR EXCEL OR PDF) |
| | I am trying to add a coloumn from database into a listbox in VB6. The following code works. The selected item from this listbox is used to find and add records to the ListBox2. Using Oracle 11g Express Edition and Visual Basic 6. Working code: (Displays the artist column from … |
| | Right now i am not working in any company.How to get oracle Support Identifiers? |
 | Hello everyone, So here's an interesting question for you all. I need to know how to retrieve all the Column Names or Primary Keys from one of the specificed database types: SQL Server, Oracle, AS400, IBMDB2. Now this has to be as a query, or more specifically I have to … |
| | I am interested to do practice on oracle database.Actually i had completed course on MYSQL,now i want to try on oracle.Today i have opened the oracle website to download oracle 11g(windows7 64bit),But in downloads only Oracle Database 11g Express Edition R2 is there.What to do now?For Mysql workbench is there …  |
| | Hi, I am using Oracle 10g on Fedora Linux and trying to learn a bit of pl/sql. Here is the piece of code that I today tried to run in the SQL Plus window but it back with an error message saying [B]SP2-0640 Not connected [/B]What could be the problem? …  |
| | the relation betwwen student and course entity is many to many.but it is not recommended .how can we convert it to two one to many relationships? |
| | How to create a JDBC for Oracle and MySQL?  |
| | How to read oracle control file's data using a shell script? Shell script is in Unix. |
| | please, what are the best resources for Oracle starters to be profficional? |
| | Kindly note that I have the below table, I am trying to spool the count of the sum of the amtpd by grouping the duedt where it is less than or equal to 31-dec-2013, but the amtpd that has the duedt of 31-dec-2013 and that has trndt between 01-dec-2013 and … |
 | Hi all, I started to look into event handlers, and there is something I would like to ask, sorry if this is a silly one. I can see that different Java components generate different events when the user interacts with them, but when it comes down to 1)which interface the … |
| | Hi to all, Im going through JDBC currently, I got struck with Java.lang.ArrayIndexOutofBounds Exception:0. I'm not getting the solution to this exception. Please help me to solve this exception, thanks in advance. import java.sql.*; class Select { public static void main(String args[]) { try { Class.forName("jdbc.oracle.driver.OracleDriver"); Connection con = DriverManager.getConnection … |
| | Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by … |
| | Hi, Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes: I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour. Here … |
 | hello, i want to ask why my function cant be called here's the function create or replace function hitung_denda (idPinjam number, tggl varchar2) return number is denda number; tgl1 date; tgl date; begin select tgl_batas into tgl1 from peminjaman where id_pinjam=idPinjam; tgl:=to_date (tggl, 'MM/DD/YYYY'); if tgl>tgl1 then select (tgl-tgl_batas)*1000 into … |
 | I am new in apex. I want to write a trigger in apex for before insert. I have to standard object (Contact, Opportunity). SELECT sum(amount), Bussiness__c from opportunity where stagename='Closed Won' and id='006i000000Kt683AAB' group by Bussiness__c I want when trigger runs this get sum(Amount) field and Bussiness__c value and then … |
 | hello So i have problem in connecting to my oracle database on the server it threw an exception like this "The type initializer for 'Oracle.DataAccess.Client.OracleParameter' threw an exception". my supervisor told me that it might be a referencing problem in this library Oracle.DataAccess.Client.OracleParameter,but i think that the library doesnt fing … |
| | I dont know is it usful? Its now Oracle , not SUN ,please tell me whether this book wil be helpful for exam?Thanks! |
| | I want perl scripts of matching the exact word between text file(.txt) and database(oracle/mysql)... suppose... Data in try.txt file, xyz abc and Data in oracle database is, qid column1 column2 1 xyz cde 2 ifg mno Here matching word is "xyz". If matching found, it will automatically delete the row … |
 | Hi All, I'm trying to connect to a mysql database using the MySQL Connector from Oracle. I'm hitting my first issue of linking the libraries and was hoping that someone could nudge me in the right direction. What I have done so far: Downloaded mysql-connector-c-6.1.3-osx10.7-x86_64.dmg from http://dev.mysql.com/downloads/connector/c/ In XCode, in …  |
The End.