As both are oracle-databases a database link can be used to solve this, given you have the privileges inside the DB to create it.
If you have the privileges in bbbb you can do something like this after you connect:
Code:
create database link aaaa connect to scott identified by tiger using 'aaaa';
insert into your_table (your,field,list)
select your,field,replace(list,'what','with')
from your_table@aaaa;
drop database link aaaa;
Hi folks,
Happy new year.
I have a file 'filename' that i wd like to split basing on the contents in the last column.
The 'filename' content looks like
256772744788,9,11
256772744805,9,11
256772744792,9,11
256775543055,10,12
256782625357,9,12
256772368953,10,13
256772627735,10,13... (3 Replies)
hi 2 all
i need to get single column from one csv file
anyone help me !
>cat file.csv
name,age
x,1
y,2
z,3
Use code tags please, ty.
in this "file.csv" file i need only name column
can u help me !:b::b: (7 Replies)
Hi,
I am trying to get the file in particular pattern using shell script. I have to add one column to some other file.
For example consider two file as below.
File1:
name1
name2
name3
File2:
Add1 age1
Add2 age2
Add3 age3
I want this two file in a single file format something like... (3 Replies)
Hi All,
I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump.
Is that possible in oracle. What will be the command for that? (6 Replies)
Hi All,
I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server.
Now how to import the dump to the... (3 Replies)
Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (2 Replies)
Hi,
I have 2 csv/txt files with single columns. I am trying to merge them using paste, but its not working..
output3.csv:
flowerbomb
everlon-jewelry
sofft
steve-madden
dolce-gabbana-watchoutput2.csv:
http://www1.abc.com/cms/slp/2/Flowerbomb
http://www1.abc.com/cms/slp/2/Everlon-Jewelry... (5 Replies)
1. The problem statement, all variables and given/known data:
are the oracle dump files compatible to direct import into db2?
I already tried many times but it always truncated results.
anyone can help/ advice or suggest?
2. Relevant commands, code, scripts, algorithms:
exp... (3 Replies)
On an OmniOS server, I removed a single-disk pool I was using for testing.
Now, when I run zpool import it will show it as FAULTED, since that single disk not available anymore.
# zpool import
pool: fido
id: 7452075738474086658
state: FAULTED
status: The pool was last... (11 Replies)
Discussion started by: priyadarshan
11 Replies
LEARN ABOUT PHP
fbsql_database_password
FBSQL_DATABASE_PASSWORD(3) 1 FBSQL_DATABASE_PASSWORD(3)fbsql_database_password - Sets or retrieves the password for a FrontBase databaseSYNOPSIS
string fbsql_database_password (resource $link_identifier, [string $database_password])
DESCRIPTION
Sets and retrieves the database password used by the connection. If a database is protected by a database password, the user must call
this function before calling fbsql_select_db(3).
If no link is open, the function will try to establish a link as if fbsql_connect(3) was called, and use it.
This function does not change the database password in the database nor can it be used to retrieve the database password for a database.
PARAMETERS
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
o $database_password
- The database password, as a string. If given, the function sets the database password for the specified link identifier.
RETURN VALUES
Returns the database password associated with the link identifier.
EXAMPLES
Example #1
fbsql_create_clob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
fbsql_database_password($link, "secret db password");
fbsql_select_db($database, $link);
?>
SEE ALSO fbsql_connect(3), fbsql_pconnect(3), fbsql_select_db(3).
PHP Documentation Group FBSQL_DATABASE_PASSWORD(3)