how do i add data file to a tablespace in oracle 9i?
473727
sql> alter tablespace tbs1 add datafile '/../../datafile4.dbf' size 400m autoextend on next 10m maxsize 600m; \n\nhope it helps
1122852
Try here:\n\nhttp://www.oraclesource.net/index.php
588044
what about it \n\nmake the database  then make the interface ..
896120
and also u have to give the all the fileds. \nint database there r 3 files, like Name, Age, Date, Table name is "details"\n\ninsert into details values ('Natarajan',23,'29-01-1983');\n\nthis is the correct way. don't mis any field...\n\nif u want to insert only some fileds.\n\ninsert into details(name,age) values('Natarajan',22);\n\nthats it...
1132417
Skip calling the stored proc and use a cursor to grab the rows directly and insert them into the second table.\n\nExample cursor:\n--------------------------\nDECLARE @col1_value VARCHAR(100)\nDECLARE @col2_value VARCHAR(100)\n\nDECLARE cc CURSOR FOR\nSELECT col1, col2\nFROM table1\n\nOPEN cc\n\nFETCH NEXT FROM cc INTO @col1_value, @col2_value\n\nWHILE @@FETCH_STATUS=0\nBEGIN\n\nINSERT INTO table2 (column1, column2)\nVALUES @col1_value, @col2_value\n\nEND\n\nCLOSE cc\nDEALLOCATE cc\n--------------------------
672792
well to say..let me try to explain..\nfirst of we shall go with DataAdapter:\nDataAdapter lets u connect to the database with watever connecting string uve made n the command string that uve made...n gets the data from the database and stores this data in the DATASET.\nDataSEt is used to store the data fetched up by the DataADapter.\nWhereeas Databinding refers to binding the data, in whatever mode we require. This is mostly used when we've got to retrieve the data from many tables and shoe in the datagrid.\nMy code for the above goes like this:\n//This is to show the 'EMP' table details existing in the Oracle, using OLEDB Provider....shows the entire table details, after clicing the button1_click event...\n\nbutton1_click(..)\n{\nstrign strcon="provider=MSDAORA.1;User Id=scott;Password=tiger";\nstring strcom="select * from emp";\nOleDbDataAdapter adapter=new OleDbDataAdapter(strcom,strcon);\nDataSet dataset=new DataSet();\nadapter.Fill(dataset,"emp");\ndataGrid1.DataSource=dataset.Tables["emp"}.DefaultView;\n}\n\nThis may have some minor errors..please check out them\nHope u got what ive tryed to explain...
1152738
http://www.devx.com/dbzone/Article/17403/0/page/3\n\nOracle SQL enhances your flexibility with the release of Oracle 9i by supporting additional join syntax. Specifically, Oracle SQL (9i only) supports what it refers to as a natural join. This type of join automatically joins all columns in both tables with the same name—thus eliminating the need to include the join in a WHERE statement. The natural join may be used in both inner and outer joins using the following syntax:\n\n\nSELECT fldlist\nFROM table1 NATURAL JOIN table2
137602
create user username identified by password [default tablespace....] [temporary tablespace....]
394022
Open folder>\nFile>\nProperties>\nSharing>\nCheck
868100
Sounds like you want to use a database like Filemaker. With a database you can create custom reports that could be used as tests.
957379
check this dude...\n\nhttp://download.oracle.com/oowsf2005/666.pdf
1122186
Thats the standard Input output header file.  it must be there . you just have to set the correct path
497310
After draggin the file into Excel, your database will take only one column.\nSelect that column and go to Data > Text to columns to start the wizard you need to convert it.\n\nXLMan
591587
Tatzug is quite right that you should link directly to the tables in the database on the server, and then Access will be able to see and use the correct data type for each field.  You do this as follows:\n\n1.  Set up an ODBC link to the SQL Server\n\nYou do this using the "DataSources (ODBC)" control panel, which is found under Administrative Tools.  This is actually a "wizard" which will lead you through the process of creating the ODBC link.\n\n2.  Inside Access, go to the File menu and select Get External Data, then Link Tables.\n\nWhen the file dialog opens, switch the File Type at the bottom to "ODBC Databases ()" and select the ODBC link you created in step 1.\n\nThen you'll get a dialog box which will allow you to select the database tables on the server you want to link to.\n\nGood luck!
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
449359
Go to Oracle's TechNet Web Site\nhttp://www.oracle.com/technology/products/forms/index.html
112568
refer these urls..\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_5b1v.asp\n\njust surf through the bookmark on left hand side..\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_30s5.asp\n\n\nalso refer this one..simple n straight forward\nhttp://www.1keydata.com/sql/sql-create-index.html