Hi
What is the best way to import table back which has dependency?
SQL> create table test (a number);
Table created.
SQL> create table test2 (b number);
Table created.
SQL> alter table test2 add constraint pk_test2 primary key(b);
Table altered.
SQL> ALTER TABLE test add CONSTRAINT fk_test FOREIGN KEY (a) REFERENCES test2(b);
Table altered.
exp system/**** file=C:/test2.dmp tables=test2
About to export specified tables via Conventional Path ...
. . exporting table TEST2 0 rows exported
Export terminated successfully without warnings.
Sometime later, I want to import table test2. Inorder to achieve this I need to drop table first and then start import.
SQL> drop table test2;
drop table test2
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
If I use cascade option, I will lose the foreign key in other table.
What should I do in this issue?
Time script, set to my time zone?
I am using this line to get the date and timeCode: $time = date(F." ".d.", ".Y." ".g.":".i.":".sa,time());How could I change this to my time zone here
Convert Binary String to Decimal
Trying to Get:Decimal: 305419896Out of:Binary String: xV4
mysql select query problem
how can i select multiple fields from multiple table in one query likei have table name t1 and t2t1 fields are f_id,f_name,f_dest2 fields are f_id,ft_name,ft_desi need query which select f_id from
Log $_POST
How would i log submits on a form, by everyone? I want to then echo the number of submissions.I've tried this:Code: [Select]<?phpif (isset($_POST['submit'])) {$myFile =
how to insert value
I am having file bookissueadd.php..... in which i am having tag <td height="21">Issue Charges</td> <td><div
Run function every 5 mins ??
I have a function PostMessage()How can I run it every 5 mins ??
Data Function is Its Not working IN IE8
This is my first time to use formums. I hope i can get solution for this problem.
Probably Easy, Need help with Check Boxes in PHP Code
hello,Thanks for looking this over and helping me out. My problem is I have a online store locator database and whats happening is I keep getting an "array" message when I look at the store.
Whats wrong with my query?
I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are ticked then I want it to display all vehicle roof heights. However it doesn't work correctly, for
void* and sizeof()
Hi,Using void* and sizeof is it possible to get the value of the object ?I understand that dereferencing a void pointer is not directly possible. Is there a way (like casting) or something else to get
