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 is from table2. Thank you.

Member Avatar
Member Avatar
-1 forum 1

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 a music database) Private Sub Command3_Click() Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset Dim ConnStr As String Dim SQL As String ConnStr = "DSN=MusicDB" SQL = "Select artist FROM music" con.Open ConnStr, "SYSTEM", "PASSWORD" rec.Open SQL, con, adOpenStatic, adLockOptimistic Do While Not rec.EOF List1.AddItem rec.Fields("artist").Value rec.MoveNext Loop …

Member Avatar
Member Avatar
+0 forum 1

Hi, If I could please get some help? I have missed the lectures on creating tables due to my daughter being sick. I am trying to follow the lecture notes but I am having issues. I get the following error Error at Command Line : 4 Column : 21 Error report - SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" `*Cause: *Action: CREATE TABLE Film ( film_code number(5)PRIMARY KEY, title varchar2 (200)FOREIGN KEY, running_time number(3,2) NOT NULL, classification varchar2(200), ); Any help would be welcome. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 2

file FMLRSVCWebpp.war does not exist ,what should i do ????

Member Avatar
Member Avatar
+0 forum 1

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 .... all these are not working error is given ora- 12560 TNS :protocol adapter error

Member Avatar
+0 forum 0

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'] = TRUE; $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = ''; $db['default']['char_set'] = 'utf8'; $db['default']['dbcollat'] = 'utf8_general_ci'; $db['default']['swap_pre'] = ''; $db['default']['autoinit'] = TRUE; $db['default']['stricton'] = FALSE; Note: I added the C:\instantclient_11_2 to environment variable to PATH. oracle port number:1521 oracle hostname: Home-pc database name: orcl Only when I run my CodeIgniter …

Member Avatar
Member Avatar
+0 forum 2

Hi, I am new to Oracle. I have installed Oracle 11g R2 standard edition (server software, 2GB download from Oracle). I found that the 'Environment Variable PATH' has not been set. Which of these directory should I use for the PATH value:- 1. Oracle base, 2. Software location or 3. Database file location Also do I need to create 'TNS_ADMIN' environment variable and 'TNSNAMES.ora' file Kindly advice. Thank you

Member Avatar
Member Avatar
+0 forum 1

The End.