Database

CDatabase database;
CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)";  // exactly the same name as in the ODBC-Manager

CString sExcelFile =_T("C:\\Users\\Admin\\Desktop\\1.xls");// Filename and path for the file to be created

CString Query_Str="";

TRY  
{ 

	Query_Str.Format(_T("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s"),                
	sDriver, sExcelFile, sExcelFile);     // Create the database (i.e. Excel sheet)

	if( database.OpenEx(Query_Str,CDatabase::noOdbcDialog) )
	{
		// Create table structure
		Query_Str = "CREATE TABLE demo (Name TEXT)";
		database.ExecuteSQL(Query_Str);

		// Insert data
		Query_Str = "INSERT INTO demo (Name) VALUES ('Albert')";
		database.ExecuteSQL(Query_Str); 

		//add column
		Query_Str = "ALTER TABLE demo ADD Col2 TEXT";
		database.ExecuteSQL(Query_Str);
	}
	// Close database
	database.Close();

}  
CATCH_ALL(e)
{    
	AfxMessageBox(e->ReportError());
}
END_CATCH_ALL;

can u please help me to ALTER TABLE with DEFAULT

Eddy Vluggen wrote:

First add all the columns and do the insert when all columns are present, or
make sure that the column you're going to add accepts null-values.

Le@rner wrote:

get all column name list of current database.

Did you mean get all column name list of current table.

Blue_Boy wrote:

Did you mean get all column name list of current table.

ERROR at line 7:
ORA-06550: line 7, column 7:
PLS-00103: Encountered the symbol "S" when expecting one of the following:
. ( * @ % & - + / at loop mod remainder rem ..
<an exponent (**)> || multiset
The symbol "loop" was substituted for "S" to continue.
ORA-06550: line 8, column 27:
PLS-00103: Encountered the symbol "`" when expecting one of the following:
( ) - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table continue avg count current exists max min pr
ORA-06550: line 9, column 24:
PLS-00103: Encountered the symbol "`" when expecting one of the following:
( ) - + case mod new not null select <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table continue avg count current exists max

DECLARE
        cursor  c1 is select * from dept;
        cursor  c2 is select * from emp;
        s emp.sal % type;
BEGIN
    for i in c1
    loop
        s:=0;
        dbms_output.put_line(‘-----------------------------------------------------’);
        dbms_output.put_line(‘Department is:’║ i.deptno║’Department name is:’║i.dname);
        dbms_output.put_line(‘---------------------------------------------------------’);
        for j in c2
        loop
            if(i.deptno=j.deptno)then
                s:=s+j.sal;
                dbms_output.put_line(j.empno║ ‘ ‘║j.ename ║’ ‘║j.sal);
            end if;
        end loop;
        dbms_output.put_line(‘--------------------------------------------------------’);
        dbms_output.put_line (‘Total salary is:’║s);
        dbms_output.put_line(‘--------------------------------------------------------’);
    end loop;
END;
/