[oracle] Forum Topics

Getting an empty drop-down list by the following code. Trying to fetch names from the department table. Using an oracle Database... <label for="department">Department</label> <select class="form-control" name="deptname" id="deptname"> <option selected disabled></option> <?php $dbUser = "..."; $dbPass = "..."; $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=...)(PORT=1521))(CONNECT_DATA=(SID=...)))"; $conn = oci_connect($dbUser, $dbPass, $dbConn); $sql …

Hi All, I am working on Oracle 11.2.0.3. and my requirement is, I have a table in Development(Dev) called " Dev_EMP". Have created Synosym for "Dev_EMP" as "SY_DEV_EMP" here is the structure [/code] create table Local_emp ( tran_id varchar2(10), acct_id varchar2(15) ); [/code] 2. Table which I am planning to …

Hi! I have here data: i don't have any idea on how to insert the details in TABLE2... as you can see, the parent_id is based on TABLE1, TABLE 1 TABLE 2 (INSERTED IN NEW TABLE) LEVEL TYPE_TABLE PARENT_NAME RECORD_ID OBJECT_TYPE RECORD_ID PARENT_ID (RECORD_ID FROM TABLE 1) 1 NODEB EQUIPMENT …

i'm trying to find in all tables with data in all columns.. example EMPLOYEE table with ID = 123 COLUMNS DATA ID 1 NAME TEST ADDRESS TESTADDRESS PHONE EMAIL POSITION DEV The output will be ID, NAME, ADDRESS, and POSITION.. so basically all columns with data only.. by the way, …

hi everyone i am new programer in oracle,i have save the url of the folders in the SQL server and i want to open or select a folder using the saved url by oracle plsql. I have select the url from the database, but the problem i don't know how …

Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to …

Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved …

We have a WCF web service hosted on Windows 2008 SP2/IIS 7 accessing an Oracle database. Usually data access works fine but during load testing, it often times out and logs an exception saying: Error occurred when processing XXXXXXXX Web Service Oracle.DataAccess.Client.OracleException Connection request timed out at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection …

I have a oracle query and i would like to run it by powershell using ODP.Net. Below is the query. set pagesize 100 set linesize 200 break on report compute sum of free_mb on report compute sum of act_size on report compute sum of used_mb on report col %used format …

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)

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 | …

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 …

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 …

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 …

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 …

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...

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 …

Hi Guys, I need help with inserting date from HTML <input type="date"/> into oracle DB It seems that i need to make some kind of adjustment with oracle date. please help me...

Hi I have a question with my code. I implemented drop down list populated from my oracle DB. So my question is, I need to populate the rest of the data into my <input type="number" min="currCutting" max="currQty" /> tag that pulled from the database according to the Head_mark selected from …

Hi! HOw do I able to export the table schema (w/ data) in oracle using CLI. Iam using oracle 9i, Is anyone could guide me or give me some instruction on how to do it. I am new with this and trying to explore.. I already tried to search the …

/*I have a situation where in I have to convert the TSQL code to PLSQL procedure. For the purpose of better understanding, I have created temp tables in place of source tables. Can I get hep on this please. The code is as follows: */ ---create temp tables CREATE TABLE …

Hello, So shortly I am receiving an SQL Error: ORA-00932: inconsistent datatypes: expected NUMBER got OE.CUST_ADDRESS_TYP 00932. 00000 - "inconsistent datatypes: expected %s got %s" when I am trying to retrieve a part of a string data. SELECT dbms_lob.SUBSTR(cus.cust_address, 0, INSTR(cus.cust_address, ',')-1) AS output FROM oe.customers cus; So basically that's …

hey.. Guys can you tell me by default password for this setup oracle 11g home . bcoz of when i was installed that time didn't asked any user and password information . please anyone can help me . but i'm trying deafult user those above said article system/orale and system/system …

i created a pl/sql program in which i want to take multiple inputs from user.. i wrote that n:=&n; in a loop ,i though it will take,but its not working... is there any way to take multiple inputs from user in oracle????

Can We write a stored proceudre that can generate session id uniquely??? is there any concept in oracle that can generate any ids unique??? can we use sequences??? pls help me...

Hey every body , Just need a bit of help with a problem understanding something. When I install Oralce onto a computer what are the default tablespaces and their role in the whole thing. What information is held in the DATA_DICTIONARY for examining tablespaces and their status? Is my second …