9 More Discussions You Might Find Interesting
1. Programming
Hello,
I have a database called "audit_database" and I want to create two tables.
Table 1 = Table 1
Table 2 = Audit
I want to partition the Audit table into partitions grouped by month. I'm not familiar with table partitioning but doing some reading online shows that it can be done but... (4 Replies)
Discussion started by: bbbngowc
4 Replies
2. Programming
I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records. (4 Replies)
Discussion started by: ramkumar15
4 Replies
3. UNIX and Linux Applications
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
4. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
5. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
6. Shell Programming and Scripting
Hi, I'm trying to write a program with unix shell scripting to track the changes of a particular table in the Oracle database.
I've try reading up on sql TRIGGER function, but I'm not sure if its feasible here. Any idea what kind of syntax should I use to track the changes in the table? Can... (0 Replies)
Discussion started by: mervinboyz
0 Replies
7. Shell Programming and Scripting
Hi
Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database.
Requirement:-
1. Need to connect to Oracle database from Unix Shell script.
2. Need to pick Text file from some location on Unix Box.
3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies
8. Shell Programming and Scripting
Hi,
I wrote a perl script to create and upload data to a mysql data base. Please see the script as shown below,
#!/usr/bin/perl -w
#Defenetion of modules use in this scrpt
use CGI qw(:standard);
use DBI ;
my $datetable1 = `date +%Y%m%d`;
my $datetable = $datetable1 ;
print... (2 Replies)
Discussion started by: maheshsri
2 Replies
9. UNIX for Advanced & Expert Users
Hi all,
i am new to the unix enviorment i have got a urgent requirement where we need to migrate the date from the folder heirachy that contains the "IMAGES". These images are to be uploaded on to the database table.
Uploading images from the a single folder (Static) to the... (0 Replies)
Discussion started by: shashisaini24
0 Replies