how to convert dates to character strings? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
Does it possible to pass object (or) table as an argument to a remote procedure?
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
Can we create foreign key without primary key?
What is the purpose of the sql select top clause?
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
What is tuple in sql?
what is the use of set statement in tsql? : Transact sql
Which table is left in join?
what is the difference between myisam static and myisam dynamic? : Sql dba
Explain alias in sql?
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
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)