how to load data with out header and footer records in a
database using sql*loader? pls tell me the answer urgently
write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/
What is exit statement?
Can we rollback truncate?
What is %rowtype in pl sql?
I have a CURSOR then why we need BULK COLLECT again?
Is primary key clustered or nonclustered?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
How to get employee name from employee table which is the fiveth highest salary of the table
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
What is numeric function sql?
we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
what is a database? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)