1,488 Topics
 | |
| | I got a requirement. i have a tabular form with some records, for example i have a department table in a tabular form, if i check first record that means department 10 and then if i click any button we need to show the list of employees whose department is … |
| |  Im wondering to solve the given task but ended up in nothing.. Can someone help me on this !? Do click here for the image file for the elobarted question . [Click Here](https://onedrive.live.com/redir?resid=70CCAC35D1F2DEFA!693&authkey=!AOy2XqxgwvxJ8yM&v=3&ithint=photo%2cpng) |
| | Okay so let me start by saying I have a pretty decent c++ base and very advanced logic skills. So whatever help you will have to provide will probably be minimal. So here's my problem: I've been trying to figure out the best way to organize all my Magic: The … |
| | im make program using vb6 n tried to get data from msaccess database ,display it in vb6 and save the data to oracle table database.. The table name in oracle is testcoba. Now i can save the data from vb6 to oracle table. But i want is the data will …  |
| | Hi guys. I am looking for a software tools that can analyse data from several sources like databases: Oracle,Mysql,Access,MsSql e.t.c and draw graphs,dashboards or other data visualisation objects. The software should also be able to read excel sheet and analyse the data and give output in variuos graphs/pie charts. It … |
| | Hi, I am new in pl/sql programming and I need your help. I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1 ================================================ |COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7| =============================================== |600 | 140 | 2 | … |
| | Hello, I am `Inserting` the data into table1 where c1 is new column and data is from table2. but c2 data type is `varchar2` and c1 datatype is `Number format`. ` INSERT INTO table1 (to_number(USER_ID)) SELECT EMP_ID FROM table2 WHERE USER_NAME IN (SELECT UNAME FROM table1); ` Here `USER_NAME` column …  |
 | Hi I got this error ORA-01403 "no data found" and ORA-06512: at line 8 however I'm sure that there is date in my table dept!!! Declare v_deptid dept.deptid%type; v_deptname dept.deptname%type; v_location dept.location%type; v_employeeid dept.employeeid%type; begin select deptid, deptname, location, employeeid into v_deptid, v_deptname, v_location, v_employeeid from dept where deptname = … |
 | Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance … |
| | Hi Why I got error ? CREATE TABLE customer_table( KNR INTEGER(10) FN VARCHAR2(10) NOT NULL, EN VARCHAR2(10) NOT NULL, Mobil NUMBER(10) NOT NULL, Tell INTEGER(10) NOT NULL, constraint knr_pk primary key(KNR) ); Error report - 00907. 00000 - "missing right parenthesis" *Cause: *Action: |
| | 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. … |
The End.