Database
After creating a table in SQL, I wish to change the size allotted to a particular column (say, I want to change the size of the salary column from 3 to 4).
But I could find no option in the SQL developer version, is there any command to modify this?
- 3104 views
- 1 answers
- 0 votes
While creating a table for emails in mysql database it shows the following error: "#1064 – You have an error in your SQL syntax"
the following code I tried:
'
'
—
— Table structure for table `coming_soon_emails`
—
CREATE TABLE `coming_soon_emails` (
`email` varchar(64) collate utf8_unicode_ci NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- 973 views
- 3 answers
- 0 votes
How can I create a password for my localhost? I can not find the exact way to do that.
- 989 views
- 2 answers
- 1 votes
Can we download a excel file by using oracle database. Also, Can we upload it the same?
I don't know much about the database.
Please help in this regard.
- 905 views
- 1 answers
- 0 votes
Hello,
I am looking to authenticate users on my website based on data that's in an Oracle database. But I am having difficulties finding accurate data on the web. Can some one guide me? I need the query of Oracle database that run in PHP.
Thanks in advance.
- 1244 views
- 1 answers
- 0 votes
- 1152 views
- 1 answers
- 0 votes
Hello
I have two tables in my sql database one is "vendor" and other "purchase_order" they both have one common attribute "vendor_name" my problem is that i want vendor name in my "purchase_order" table to be same as that in "vendor" table but vendor_name is not a primary key in "vendor" table so i cannot use primary key_foreign_key reference.
Could anyone help me what should I use?
Thanks
- 923 views
- 1 answers
- 0 votes
How can I create a Crystal Report and use Visual Studio 2008 and MS Access 2010 as the base table?
- 1683 views
- 1 answers
- 0 votes
I have made a database that consists of product codes with their corresponding prices. I encoded the product codes and then tried to update the database but when running the MDF file, it is still showing the updated product codes. Does anyone knows how to avoid this permanently?
- 832 views
- 1 answers
- 0 votes
The error message below always shows up every time I try to go to Business Intelligence > core application in the Oracle Enterprise Manager Fusion Middleware Control:
“Stream Close” “For more information, please see the server’s error log for an entry beginning with: Server Exception during PPR, #7”
- 979 views
- 2 answers
- 0 votes